<!DOCTYPE html>
<html lang="en">

<!-- Head tag -->
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="description" content="A very lame cool person">
    <meta name="keyword" content="null">
    <meta name="theme-color" content="#600090">
    <meta name="msapplication-navbutton-color" content="#600090">
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="apple-mobile-web-app-status-bar-style" content="#600090">
    <link rel="shortcut icon" href="/favicon.ico">
    <link rel="alternate" type="application/atom+xml" title="Guanghui" href="/atom.xml">
    <link rel="stylesheet" href="//cdnjs.cloudflare.com/ajax/libs/animate.css/3.5.2/animate.min.css">
    <link rel="stylesheet" href="//cdn.bootcss.com/font-awesome/4.6.3/css/font-awesome.css">
    <title>
        
        Asp.net MVC系列教程6——丰富数据表、建立关联｜Guanghui&#39;s blog
        
    </title>

    <link rel="canonical" href="https://wghglory.github.io/2017/02/17/mvc-lesson6/">

    <!-- Bootstrap Core CSS -->
    <link rel="stylesheet" href="/css/bootstrap.min.css">

    <!-- Custom CSS -->
    <link rel="stylesheet" href="/css/blog-style.css">

    <link rel="stylesheet" href="/css/my.css">

    <!-- Pygments Github CSS -->
    <link rel="stylesheet" href="/css/syntax.css">
</head>

<style>

    header.intro-header {
        background-image: url('/images/tag.jpg')
    }
</style>
<!-- hack iOS CSS :active style -->
<body ontouchstart="" class="animated fadeIn">
<!-- Navigation -->
<nav class="navbar navbar-default navbar-custom navbar-fixed-top " id="nav-top" data-ispost = "true" data-istags="false
" data-ishome = "false" >
    <div class="container-fluid">
        <!-- Brand and toggle get grouped for better mobile display -->
        <div class="navbar-header page-scroll">
            <button type="button" class="navbar-toggle">
                <span class="sr-only">Toggle navigation</span>
                <span class="icon-bar"></span>
                <span class="icon-bar"></span>
                <span class="icon-bar"></span>
            </button>
            <a class="navbar-brand animated pulse" href="/">
                <span class="brand-logo">
                    Guanghui
                </span>
                's Blog
            </a>
        </div>

        <!-- Collect the nav links, forms, and other content for toggling -->
        <!-- Known Issue, found by Hux:
            <nav>'s height woule be hold on by its content.
            so, when navbar scale out, the <nav> will cover tags.
            also mask any touch event of tags, unfortunately.
        -->
        <!-- /.navbar-collapse -->
        <div id="huxblog_navbar">
            <div class="navbar-collapse">
                <ul class="nav navbar-nav navbar-right">
                    <li>
                        <a href="/">Home</a>
                    </li>
					
                    
                        
							
                        <li>
                            <a href="/tags/">tags</a>
                        </li>
							
						
                    
                        
							
                        <li>
                            <a href="/works/">my works</a>
                        </li>
							
						
                    

					
                        <li>
                            <a href="https://wghglory.github.io/guanghui.resume/" target="_blank">Resume</a>
                        </li>
                </ul>
            </div>
        </div>
    </div>
    <!-- /.container -->
</nav>
<script>
    // Drop Bootstarp low-performance Navbar
    // Use customize navbar with high-quality material design animation
    // in high-perf jank-free CSS3 implementation
//    var $body   = document.body;
    var $toggle = document.querySelector('.navbar-toggle');
    var $navbar = document.querySelector('#huxblog_navbar');
    var $collapse = document.querySelector('.navbar-collapse');

    $toggle.addEventListener('click', handleMagic)
    function handleMagic(e){
        if ($navbar.className.indexOf('in') > 0) {
        // CLOSE
            $navbar.className = " ";
            // wait until animation end.
            setTimeout(function(){
                // prevent frequently toggle
                if($navbar.className.indexOf('in') < 0) {
                    $collapse.style.height = "0px"
                }
            },400)
        }else{
        // OPEN
            $collapse.style.height = "auto"
            $navbar.className += " in";
        }
    }
</script>

<!-- Main Content -->

<!--only post-->


<img class="wechat-title-img" src="/images/default-post.jpg">


<style>
    
    header.intro-header {
        background-image: url('/images/default-post.jpg');
    }

    
</style>

<header class="intro-header">
    <div class="container">
        <div class="row">
            <div class="col-lg-8 col-lg-offset-2 col-md-10 col-md-offset-1 text-center">
                <div class="post-heading">
                    <h1>Asp.net MVC系列教程6——丰富数据表、建立关联</h1>
                    
                    <span class="meta">
                         作者 Guanghui Wang
                        <span>
                          日期 2017-02-17
                         </span>
                    </span>
                    <div class="tags text-center">
                        
                        <a class="tag" href="/tags/#sql"
                           title="sql">sql</a>
                        
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="post-title-haojen">
        <span>
            <!-- Asp.net MVC系列教程6——丰富数据表、建立关联 -->
        </span>
    </div>
</header>

<!-- Post Content -->
<article>
    <div class="container">
        <div class="row">
            <!-- Post Container -->
            <div class="col-lg-8 col-lg-offset-1 col-sm-9 post-container">
                <h1 id="简述"><a href="#简述" class="headerlink" title="简述"></a>简述</h1><p>本文转自<a href="http://yuangang.cnblogs.com并加以整理。" target="_blank" rel="noopener">http://yuangang.cnblogs.com并加以整理。</a> 今天我们来建立几个表，考虑到他们之间的关系，并根据数据库生成EF实体模型。</p>
<h1 id="索引"><a href="#索引" class="headerlink" title="索引"></a>索引</h1><p><a href="/2017/02/14/mvc-lesson1/" target="_blank">Asp.net MVC项目系列教程</a></p>
<h1 id="项目开始"><a href="#项目开始" class="headerlink" title="项目开始"></a>项目开始</h1><h4 id="表名：SYS-CODE"><a href="#表名：SYS-CODE" class="headerlink" title="表名：SYS_CODE"></a>表名：SYS_CODE</h4><table>
<thead>
<tr>
<th style="text-align:left">序号</th>
<th style="text-align:left">列名</th>
<th style="text-align:left">数据类型</th>
<th style="text-align:left">长度</th>
<th style="text-align:left">小数位</th>
<th style="text-align:left">主键</th>
<th style="text-align:left">允许空</th>
<th style="text-align:left">说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align:left">1</td>
<td style="text-align:left">ID</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">否</td>
<td style="text-align:left">主键ID</td>
</tr>
<tr>
<td style="text-align:left">2</td>
<td style="text-align:left">CODETYPE</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">50</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">代码类型</td>
</tr>
<tr>
<td style="text-align:left">3</td>
<td style="text-align:left">NAMETEXT</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">200</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">代码显示文本</td>
</tr>
<tr>
<td style="text-align:left">4</td>
<td style="text-align:left">CODEVALUE</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">100</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">代码值</td>
</tr>
<tr>
<td style="text-align:left">5</td>
<td style="text-align:left">SHOWORDER</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">排序值</td>
</tr>
<tr>
<td style="text-align:left">6</td>
<td style="text-align:left">ISCODE</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">是否为编码（0否1是）</td>
</tr>
<tr>
<td style="text-align:left">7</td>
<td style="text-align:left">REMARK</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">2000</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">备注</td>
</tr>
<tr>
<td style="text-align:left">8</td>
<td style="text-align:left">CREATEDATE</td>
<td style="text-align:left">datetime</td>
<td style="text-align:left">8</td>
<td style="text-align:left">3</td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">创建时间</td>
</tr>
<tr>
<td style="text-align:left">9</td>
<td style="text-align:left">CREATEUSER</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">36</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">创建者</td>
</tr>
<tr>
<td style="text-align:left">10</td>
<td style="text-align:left">UPDATEDATE</td>
<td style="text-align:left">datetime</td>
<td style="text-align:left">8</td>
<td style="text-align:left">3</td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">修改时间</td>
</tr>
<tr>
<td style="text-align:left">11</td>
<td style="text-align:left">UPDATEUSER</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">36</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">修改者</td>
</tr>
<tr>
<td style="text-align:left">12</td>
<td style="text-align:left">PARENTID</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">父级ID（使用时注意ISCODE为0）</td>
</tr>
</tbody>
</table>
<h4 id="表名：SYS-CODE-AREA"><a href="#表名：SYS-CODE-AREA" class="headerlink" title="表名：SYS_CODE_AREA"></a>表名：SYS_CODE_AREA</h4><table>
<thead>
<tr>
<th style="text-align:left">序号</th>
<th style="text-align:left">列名</th>
<th style="text-align:left">数据类型</th>
<th style="text-align:left">长度</th>
<th style="text-align:left">小数位</th>
<th style="text-align:left">允许空</th>
<th style="text-align:left">说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align:left">1</td>
<td style="text-align:left">ID</td>
<td style="text-align:left">varchar</td>
<td style="text-align:left">50</td>
<td style="text-align:left">0</td>
<td style="text-align:left">否</td>
<td style="text-align:left">主键ID</td>
</tr>
<tr>
<td style="text-align:left">2</td>
<td style="text-align:left">PID</td>
<td style="text-align:left">varchar</td>
<td style="text-align:left">50</td>
<td style="text-align:left">0</td>
<td style="text-align:left">否</td>
<td style="text-align:left">上级ID</td>
</tr>
<tr>
<td style="text-align:left">3</td>
<td style="text-align:left">NAME</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">200</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">名称</td>
</tr>
<tr>
<td style="text-align:left">4</td>
<td style="text-align:left">LEVELS</td>
<td style="text-align:left">tinyint</td>
<td style="text-align:left">1</td>
<td style="text-align:left">0</td>
<td style="text-align:left">否</td>
<td style="text-align:left">级别</td>
</tr>
</tbody>
</table>
<h4 id="表名：SYS-DEPARTMENT"><a href="#表名：SYS-DEPARTMENT" class="headerlink" title="表名：SYS_DEPARTMENT"></a>表名：SYS_DEPARTMENT</h4><table>
<thead>
<tr>
<th style="text-align:left">序号</th>
<th style="text-align:left">列名</th>
<th style="text-align:left">数据类型</th>
<th style="text-align:left">长度</th>
<th style="text-align:left">小数位</th>
<th style="text-align:left">允许空</th>
<th style="text-align:left">说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align:left">1</td>
<td style="text-align:left">ID</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">36</td>
<td style="text-align:left">0</td>
<td style="text-align:left">否</td>
<td style="text-align:left">主键ID</td>
</tr>
<tr>
<td style="text-align:left">2</td>
<td style="text-align:left">CODE</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">100</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">部门编号，横向增长</td>
</tr>
<tr>
<td style="text-align:left">3</td>
<td style="text-align:left">NAME</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">200</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">部门名称</td>
</tr>
<tr>
<td style="text-align:left">4</td>
<td style="text-align:left">BUSINESSLEVEL</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">业务等级</td>
</tr>
<tr>
<td style="text-align:left">5</td>
<td style="text-align:left">SHOWORDER</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">部门排序</td>
</tr>
<tr>
<td style="text-align:left">6</td>
<td style="text-align:left">CREATEPERID</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">36</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">创建者编号</td>
</tr>
<tr>
<td style="text-align:left">7</td>
<td style="text-align:left">CREATEDATE</td>
<td style="text-align:left">date</td>
<td style="text-align:left">3</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">创建时间</td>
</tr>
<tr>
<td style="text-align:left">8</td>
<td style="text-align:left">PARENTID</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">36</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">上级部门ID</td>
</tr>
<tr>
<td style="text-align:left">9</td>
<td style="text-align:left">UPDATEDATE</td>
<td style="text-align:left">date</td>
<td style="text-align:left">3</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">修改时间</td>
</tr>
<tr>
<td style="text-align:left">10</td>
<td style="text-align:left">UPDATEUSER</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">36</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">修改人</td>
</tr>
<tr>
<td style="text-align:left">11</td>
<td style="text-align:left">PARENTCODE</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">100</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
</tr>
</tbody>
</table>
<h4 id="表名：SYS-MODULE"><a href="#表名：SYS-MODULE" class="headerlink" title="表名：SYS_MODULE"></a>表名：SYS_MODULE</h4><table>
<thead>
<tr>
<th style="text-align:left">序号</th>
<th style="text-align:left">列名</th>
<th style="text-align:left">数据类型</th>
<th style="text-align:left">长度</th>
<th style="text-align:left">小数位</th>
<th style="text-align:left">标识</th>
<th style="text-align:left">主键</th>
<th style="text-align:left">外键</th>
<th style="text-align:left">允许空</th>
<th style="text-align:left">说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align:left">1</td>
<td style="text-align:left">ID</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">是</td>
<td style="text-align:left"></td>
<td style="text-align:left">否</td>
<td style="text-align:left">主键ID</td>
</tr>
<tr>
<td style="text-align:left">2</td>
<td style="text-align:left">FK_BELONGSYSTEM</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">36</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">否</td>
<td style="text-align:left">所属系统</td>
</tr>
<tr>
<td style="text-align:left">3</td>
<td style="text-align:left">PARENTID</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">否</td>
<td style="text-align:left">父ID，级联</td>
</tr>
<tr>
<td style="text-align:left">4</td>
<td style="text-align:left">NAME</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">50</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">显示名称</td>
</tr>
<tr>
<td style="text-align:left">5</td>
<td style="text-align:left">ALIAS</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">50</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">别名</td>
</tr>
<tr>
<td style="text-align:left">6</td>
<td style="text-align:left">MODULETYPE</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">否</td>
<td style="text-align:left">模块类型</td>
</tr>
<tr>
<td style="text-align:left">7</td>
<td style="text-align:left">ICON</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">200</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">自定义图标</td>
</tr>
<tr>
<td style="text-align:left">8</td>
<td style="text-align:left">MODULEPATH</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">500</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">连接路径</td>
</tr>
<tr>
<td style="text-align:left">9</td>
<td style="text-align:left">ISSHOW</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">否</td>
<td style="text-align:left">是否展示（0否1是）</td>
</tr>
<tr>
<td style="text-align:left">10</td>
<td style="text-align:left">SHOWORDER</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">否</td>
<td style="text-align:left">排序值</td>
</tr>
<tr>
<td style="text-align:left">11</td>
<td style="text-align:left">LEVELS</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">否</td>
<td style="text-align:left">级别</td>
</tr>
<tr>
<td style="text-align:left">12</td>
<td style="text-align:left">IsVillage</td>
<td style="text-align:left">bit</td>
<td style="text-align:left">1</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">否</td>
<td style="text-align:left"></td>
</tr>
<tr>
<td style="text-align:left">13</td>
<td style="text-align:left">CREATEUSER</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">50</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">创建者</td>
</tr>
<tr>
<td style="text-align:left">14</td>
<td style="text-align:left">CREATEDATE</td>
<td style="text-align:left">datetime</td>
<td style="text-align:left">8</td>
<td style="text-align:left">3</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">创建时间</td>
</tr>
<tr>
<td style="text-align:left">15</td>
<td style="text-align:left">UPDATEUSER</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">36</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">修改者</td>
</tr>
<tr>
<td style="text-align:left">16</td>
<td style="text-align:left">UPDATEDATE</td>
<td style="text-align:left">datetime</td>
<td style="text-align:left">8</td>
<td style="text-align:left">3</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">修改时间</td>
</tr>
</tbody>
</table>
<h4 id="表名：SYS-PERMISSION"><a href="#表名：SYS-PERMISSION" class="headerlink" title="表名：SYS_PERMISSION"></a>表名：SYS_PERMISSION</h4><table>
<thead>
<tr>
<th style="text-align:left">序号</th>
<th style="text-align:left">列名</th>
<th style="text-align:left">数据类型</th>
<th style="text-align:left">长度</th>
<th style="text-align:left">小数位</th>
<th style="text-align:left">标识</th>
<th style="text-align:left">主键</th>
<th style="text-align:left">外键</th>
<th style="text-align:left">允许空</th>
<th style="text-align:left">说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align:left">1</td>
<td style="text-align:left">ID</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">是</td>
<td style="text-align:left"></td>
<td style="text-align:left">否</td>
<td style="text-align:left">主键ID</td>
</tr>
<tr>
<td style="text-align:left">2</td>
<td style="text-align:left">MODULEID</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">否</td>
<td style="text-align:left">模块ID</td>
</tr>
<tr>
<td style="text-align:left">3</td>
<td style="text-align:left">NAME</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">36</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">授权名称</td>
</tr>
<tr>
<td style="text-align:left">4</td>
<td style="text-align:left">PERVALUE</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">100</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">权限值（对应SYS_CODE表）</td>
</tr>
<tr>
<td style="text-align:left">5</td>
<td style="text-align:left">ICON</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">50</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">图标ID</td>
</tr>
<tr>
<td style="text-align:left">6</td>
<td style="text-align:left">SHOWORDER</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">显示排序</td>
</tr>
<tr>
<td style="text-align:left">7</td>
<td style="text-align:left">CREATEDATE</td>
<td style="text-align:left">date</td>
<td style="text-align:left">3</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">创建时间</td>
</tr>
<tr>
<td style="text-align:left">8</td>
<td style="text-align:left">CREATEUSER</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">36</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">创建者</td>
</tr>
<tr>
<td style="text-align:left">9</td>
<td style="text-align:left">UPDATEDATE</td>
<td style="text-align:left">date</td>
<td style="text-align:left">3</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">修改时间</td>
</tr>
<tr>
<td style="text-align:left">10</td>
<td style="text-align:left">UPDATEUSER</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">36</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">修改者</td>
</tr>
</tbody>
</table>
<h4 id="表名：SYS-POST"><a href="#表名：SYS-POST" class="headerlink" title="表名：SYS_POST"></a>表名：SYS_POST</h4><table>
<thead>
<tr>
<th style="text-align:left">序号</th>
<th style="text-align:left">列名</th>
<th style="text-align:left">数据类型</th>
<th style="text-align:left">长度</th>
<th style="text-align:left">小数位</th>
<th style="text-align:left">允许空</th>
<th style="text-align:left">说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align:left">1</td>
<td style="text-align:left">ID</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">36</td>
<td style="text-align:left">0</td>
<td style="text-align:left">否</td>
<td style="text-align:left">主键ID</td>
</tr>
<tr>
<td style="text-align:left">2</td>
<td style="text-align:left">POSTNAME</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">100</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">岗位名称</td>
</tr>
<tr>
<td style="text-align:left">3</td>
<td style="text-align:left">POSTTYPE</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">36</td>
<td style="text-align:left">0</td>
<td style="text-align:left">否</td>
<td style="text-align:left">岗位类型</td>
</tr>
<tr>
<td style="text-align:left">4</td>
<td style="text-align:left">REMARK</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">500</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">岗位备注</td>
</tr>
<tr>
<td style="text-align:left">5</td>
<td style="text-align:left">SHOWORDER</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">排序</td>
</tr>
<tr>
<td style="text-align:left">6</td>
<td style="text-align:left">CREATEUSERID</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">创建者ID</td>
</tr>
<tr>
<td style="text-align:left">7</td>
<td style="text-align:left">CREATEDATE</td>
<td style="text-align:left">datetime</td>
<td style="text-align:left">8</td>
<td style="text-align:left">3</td>
<td style="text-align:left">否</td>
<td style="text-align:left">创建时间</td>
</tr>
<tr>
<td style="text-align:left">8</td>
<td style="text-align:left">UPDATEDATE</td>
<td style="text-align:left">datetime</td>
<td style="text-align:left">8</td>
<td style="text-align:left">3</td>
<td style="text-align:left">是</td>
<td style="text-align:left">修改时间</td>
</tr>
<tr>
<td style="text-align:left">9</td>
<td style="text-align:left">UPDATEUSER</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">36</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">修改者</td>
</tr>
</tbody>
</table>
<h4 id="表名：SYS-POST-DEPARTMENT"><a href="#表名：SYS-POST-DEPARTMENT" class="headerlink" title="表名：SYS_POST_DEPARTMENT"></a>表名：SYS_POST_DEPARTMENT</h4><table>
<thead>
<tr>
<th style="text-align:left">序号</th>
<th style="text-align:left">列名</th>
<th style="text-align:left">数据类型</th>
<th style="text-align:left">长度</th>
<th style="text-align:left">小数位</th>
<th style="text-align:left">标识</th>
<th style="text-align:left">主键</th>
<th style="text-align:left">外键</th>
<th style="text-align:left">允许空</th>
<th style="text-align:left">说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align:left">1</td>
<td style="text-align:left">ID</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">是</td>
<td style="text-align:left"></td>
<td style="text-align:left">否</td>
<td style="text-align:left">主键ID</td>
</tr>
<tr>
<td style="text-align:left">2</td>
<td style="text-align:left">FK_DEPARTMENT_ID</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">36</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">否</td>
<td style="text-align:left">部门ID</td>
</tr>
<tr>
<td style="text-align:left">3</td>
<td style="text-align:left">FK_POST_ID</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">36</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">否</td>
<td style="text-align:left">岗位ID</td>
</tr>
</tbody>
</table>
<h4 id="表名：SYS-POST-USER"><a href="#表名：SYS-POST-USER" class="headerlink" title="表名：SYS_POST_USER"></a>表名：SYS_POST_USER</h4><table>
<thead>
<tr>
<th style="text-align:left">序号</th>
<th style="text-align:left">列名</th>
<th style="text-align:left">数据类型</th>
<th style="text-align:left">长度</th>
<th style="text-align:left">小数位</th>
<th style="text-align:left">标识</th>
<th style="text-align:left">主键</th>
<th style="text-align:left">外键</th>
<th style="text-align:left">允许空</th>
<th style="text-align:left">说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align:left">1</td>
<td style="text-align:left">ID</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">是</td>
<td style="text-align:left"></td>
<td style="text-align:left">否</td>
<td style="text-align:left">主键ID</td>
</tr>
<tr>
<td style="text-align:left">2</td>
<td style="text-align:left">FK_USERID</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">否</td>
<td style="text-align:left">用户ID</td>
</tr>
<tr>
<td style="text-align:left">3</td>
<td style="text-align:left">FK_POST_DEPARTMENTID</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">否</td>
<td style="text-align:left">岗位部门ID</td>
</tr>
</tbody>
</table>
<h4 id="表名：SYS-ROLE"><a href="#表名：SYS-ROLE" class="headerlink" title="表名：SYS_ROLE"></a>表名：SYS_ROLE</h4><table>
<thead>
<tr>
<th style="text-align:left">序号</th>
<th style="text-align:left">列名</th>
<th style="text-align:left">数据类型</th>
<th style="text-align:left">长度</th>
<th style="text-align:left">小数位</th>
<th style="text-align:left">允许空</th>
<th style="text-align:left">说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align:left">1</td>
<td style="text-align:left">ID</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left">否</td>
<td style="text-align:left">主键ID</td>
</tr>
<tr>
<td style="text-align:left">2</td>
<td style="text-align:left">ROLENAME</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">50</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">角色名称</td>
</tr>
<tr>
<td style="text-align:left">3</td>
<td style="text-align:left">ISCUSTOM</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left">否</td>
<td style="text-align:left">是否自定义（0否1是）</td>
</tr>
<tr>
<td style="text-align:left">4</td>
<td style="text-align:left">ROLEDESC</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">1000</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">角色说明</td>
</tr>
<tr>
<td style="text-align:left">5</td>
<td style="text-align:left">CREATEPERID</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">36</td>
<td style="text-align:left">0</td>
<td style="text-align:left">否</td>
<td style="text-align:left">创建者ID（关联SYS_USER的ID）</td>
</tr>
<tr>
<td style="text-align:left">6</td>
<td style="text-align:left">CREATEDATE</td>
<td style="text-align:left">datetime</td>
<td style="text-align:left">8</td>
<td style="text-align:left">3</td>
<td style="text-align:left">否</td>
<td style="text-align:left">创建时间</td>
</tr>
<tr>
<td style="text-align:left">7</td>
<td style="text-align:left">UPDATEDATE</td>
<td style="text-align:left">datetime</td>
<td style="text-align:left">8</td>
<td style="text-align:left">3</td>
<td style="text-align:left">否</td>
<td style="text-align:left">修改时间</td>
</tr>
<tr>
<td style="text-align:left">8</td>
<td style="text-align:left">UPDATEUSER</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">36</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">修改者</td>
</tr>
</tbody>
</table>
<h4 id="表名：SYS-ROLE-PERMISSION"><a href="#表名：SYS-ROLE-PERMISSION" class="headerlink" title="表名：SYS_ROLE_PERMISSION"></a>表名：SYS_ROLE_PERMISSION</h4><table>
<thead>
<tr>
<th style="text-align:left">序号</th>
<th style="text-align:left">列名</th>
<th style="text-align:left">数据类型</th>
<th style="text-align:left">长度</th>
<th style="text-align:left">小数位</th>
<th style="text-align:left">标识</th>
<th style="text-align:left">主键</th>
<th style="text-align:left">外键</th>
<th style="text-align:left">允许空</th>
<th style="text-align:left">说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align:left">1</td>
<td style="text-align:left">ID</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">是</td>
<td style="text-align:left"></td>
<td style="text-align:left">否</td>
<td style="text-align:left">主键ID</td>
</tr>
<tr>
<td style="text-align:left">2</td>
<td style="text-align:left">ROLEID</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">否</td>
<td style="text-align:left">角色ID</td>
</tr>
<tr>
<td style="text-align:left">3</td>
<td style="text-align:left">PERMISSIONID</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">否</td>
<td style="text-align:left">授权ID</td>
</tr>
</tbody>
</table>
<h4 id="表名：SYS-SYSTEM"><a href="#表名：SYS-SYSTEM" class="headerlink" title="表名：SYS_SYSTEM"></a>表名：SYS_SYSTEM</h4><table>
<thead>
<tr>
<th style="text-align:left">序号</th>
<th style="text-align:left">列名</th>
<th style="text-align:left">数据类型</th>
<th style="text-align:left">长度</th>
<th style="text-align:left">小数位</th>
<th style="text-align:left">允许空</th>
<th style="text-align:left">说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align:left">1</td>
<td style="text-align:left">ID</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">36</td>
<td style="text-align:left">0</td>
<td style="text-align:left">否</td>
<td style="text-align:left">主键ID</td>
</tr>
<tr>
<td style="text-align:left">2</td>
<td style="text-align:left">NAME</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">200</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">系统名称</td>
</tr>
<tr>
<td style="text-align:left">3</td>
<td style="text-align:left">SITEURL</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">500</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">系统地址</td>
</tr>
<tr>
<td style="text-align:left">4</td>
<td style="text-align:left">IS_LOGIN</td>
<td style="text-align:left">tinyint</td>
<td style="text-align:left">1</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">是否允许登录系统（0否1是）</td>
</tr>
<tr>
<td style="text-align:left">5</td>
<td style="text-align:left">DOCKUSER</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">100</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">系统对接用户名</td>
</tr>
<tr>
<td style="text-align:left">6</td>
<td style="text-align:left">DOCKPASS</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">200</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">系统对接密码</td>
</tr>
<tr>
<td style="text-align:left">7</td>
<td style="text-align:left">CREATEDATE</td>
<td style="text-align:left">date</td>
<td style="text-align:left">3</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">系统创建时间</td>
</tr>
<tr>
<td style="text-align:left">8</td>
<td style="text-align:left">REMARK</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">2000</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">备注</td>
</tr>
</tbody>
</table>
<h4 id="表名：SYS-USER-DEPARTMENT"><a href="#表名：SYS-USER-DEPARTMENT" class="headerlink" title="表名：SYS_USER_DEPARTMENT"></a>表名：SYS_USER_DEPARTMENT</h4><table>
<thead>
<tr>
<th style="text-align:left">序号</th>
<th style="text-align:left">列名</th>
<th style="text-align:left">数据类型</th>
<th style="text-align:left">长度</th>
<th style="text-align:left">小数位</th>
<th style="text-align:left">标识</th>
<th style="text-align:left">主键</th>
<th style="text-align:left">外键</th>
<th style="text-align:left">允许空</th>
<th style="text-align:left">说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align:left">1</td>
<td style="text-align:left">ID</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">是</td>
<td style="text-align:left"></td>
<td style="text-align:left">否</td>
<td style="text-align:left">主键ID</td>
</tr>
<tr>
<td style="text-align:left">2</td>
<td style="text-align:left">USER_ID</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">否</td>
<td style="text-align:left">用户ID</td>
</tr>
<tr>
<td style="text-align:left">3</td>
<td style="text-align:left">DEPARTMENT_ID</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">36</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">否</td>
<td style="text-align:left">部门ID</td>
</tr>
</tbody>
</table>
<h4 id="表名：SYS-USER-PERMISSION"><a href="#表名：SYS-USER-PERMISSION" class="headerlink" title="表名：SYS_USER_PERMISSION"></a>表名：SYS_USER_PERMISSION</h4><table>
<thead>
<tr>
<th style="text-align:left">序号</th>
<th style="text-align:left">列名</th>
<th style="text-align:left">数据类型</th>
<th style="text-align:left">长度</th>
<th style="text-align:left">小数位</th>
<th style="text-align:left">标识</th>
<th style="text-align:left">主键</th>
<th style="text-align:left">外键</th>
<th style="text-align:left">允许空</th>
<th style="text-align:left">说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align:left">1</td>
<td style="text-align:left">ID</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">是</td>
<td style="text-align:left"></td>
<td style="text-align:left">否</td>
<td style="text-align:left">主键ID</td>
</tr>
<tr>
<td style="text-align:left">2</td>
<td style="text-align:left">FK_USERID</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">否</td>
<td style="text-align:left">用户ID</td>
</tr>
<tr>
<td style="text-align:left">3</td>
<td style="text-align:left">FK_PERMISSIONID</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">否</td>
<td style="text-align:left">授权ID</td>
</tr>
</tbody>
</table>
<h4 id="表名：SYS-USER-ROLE"><a href="#表名：SYS-USER-ROLE" class="headerlink" title="表名：SYS_USER_ROLE"></a>表名：SYS_USER_ROLE</h4><table>
<thead>
<tr>
<th style="text-align:left">序号</th>
<th style="text-align:left">列名</th>
<th style="text-align:left">数据类型</th>
<th style="text-align:left">长度</th>
<th style="text-align:left">小数位</th>
<th style="text-align:left">标识</th>
<th style="text-align:left">主键</th>
<th style="text-align:left">外键</th>
<th style="text-align:left">允许空</th>
<th style="text-align:left">说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align:left">1</td>
<td style="text-align:left">ID</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left">是</td>
<td style="text-align:left">是</td>
<td style="text-align:left"></td>
<td style="text-align:left">否</td>
<td style="text-align:left">主键ID</td>
</tr>
<tr>
<td style="text-align:left">2</td>
<td style="text-align:left">FK_USERID</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">否</td>
<td style="text-align:left">用户ID</td>
</tr>
<tr>
<td style="text-align:left">3</td>
<td style="text-align:left">FK_ROLEID</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">否</td>
<td style="text-align:left">角色ID</td>
</tr>
</tbody>
</table>
<h4 id="表名：SYS-USERINFO"><a href="#表名：SYS-USERINFO" class="headerlink" title="表名：SYS_USERINFO"></a>表名：SYS_USERINFO</h4><table>
<thead>
<tr>
<th style="text-align:left">序号</th>
<th style="text-align:left">列名</th>
<th style="text-align:left">数据类型</th>
<th style="text-align:left">长度</th>
<th style="text-align:left">小数位</th>
<th style="text-align:left">标识</th>
<th style="text-align:left">主键</th>
<th style="text-align:left">外键</th>
<th style="text-align:left">允许空</th>
<th style="text-align:left">说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align:left">1</td>
<td style="text-align:left">ID</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left"></td>
<td style="text-align:left">否</td>
<td style="text-align:left">主键ID</td>
</tr>
<tr>
<td style="text-align:left">2</td>
<td style="text-align:left">USERID</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">否</td>
<td style="text-align:left">用户ID，外键</td>
</tr>
<tr>
<td style="text-align:left">3</td>
<td style="text-align:left">POSTCODE</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">职务，编码</td>
</tr>
<tr>
<td style="text-align:left">4</td>
<td style="text-align:left">PHONE</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">200</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">手机号码</td>
</tr>
<tr>
<td style="text-align:left">5</td>
<td style="text-align:left">OFFICEPHONE</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">200</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">办公电话</td>
</tr>
<tr>
<td style="text-align:left">6</td>
<td style="text-align:left">EMAILADDRESS</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">200</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">Email</td>
</tr>
<tr>
<td style="text-align:left">7</td>
<td style="text-align:left">SECONDPHONE</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">200</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">第二手机号码</td>
</tr>
<tr>
<td style="text-align:left">8</td>
<td style="text-align:left">WORKCODE</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">在岗状态，编码</td>
</tr>
<tr>
<td style="text-align:left">9</td>
<td style="text-align:left">SEXCODE</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">性别，编码</td>
</tr>
<tr>
<td style="text-align:left">10</td>
<td style="text-align:left">BIRTHDAY</td>
<td style="text-align:left">datetime</td>
<td style="text-align:left">8</td>
<td style="text-align:left">3</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">出生日期</td>
</tr>
<tr>
<td style="text-align:left">11</td>
<td style="text-align:left">NATIONCODE</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">民族，编码</td>
</tr>
<tr>
<td style="text-align:left">12</td>
<td style="text-align:left">IDNUMBER</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">18</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">身份证号码</td>
</tr>
<tr>
<td style="text-align:left">13</td>
<td style="text-align:left">MARRYCODE</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">婚姻状况，编码</td>
</tr>
<tr>
<td style="text-align:left">14</td>
<td style="text-align:left">IDENTITYCODE</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">政治面貌，编码</td>
</tr>
<tr>
<td style="text-align:left">15</td>
<td style="text-align:left">HomeTown</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">200</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">籍贯，编码（关联至TBCode_Area的CodeValue）</td>
</tr>
<tr>
<td style="text-align:left">16</td>
<td style="text-align:left">ACCOUNTLOCATION</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">200</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">户籍所在地</td>
</tr>
<tr>
<td style="text-align:left">17</td>
<td style="text-align:left">XUELI</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">学历，编码</td>
</tr>
<tr>
<td style="text-align:left">18</td>
<td style="text-align:left">ZHICHENG</td>
<td style="text-align:left">int</td>
<td style="text-align:left">4</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">职称，编码</td>
</tr>
<tr>
<td style="text-align:left">19</td>
<td style="text-align:left">GRADUATIONSCHOOL</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">200</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">毕业院校</td>
</tr>
<tr>
<td style="text-align:left">20</td>
<td style="text-align:left">SPECIALTY</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">200</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">专业</td>
</tr>
<tr>
<td style="text-align:left">21</td>
<td style="text-align:left">PHOTOOLDNAME</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">200</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">照片原文件名</td>
</tr>
<tr>
<td style="text-align:left">22</td>
<td style="text-align:left">PHOTONEWNAME</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">200</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">照片新文件名</td>
</tr>
<tr>
<td style="text-align:left">23</td>
<td style="text-align:left">PHOTOTYPE</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">200</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">照片格式</td>
</tr>
<tr>
<td style="text-align:left">24</td>
<td style="text-align:left">RESUMEOLDNAME</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">200</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">简历原文件名</td>
</tr>
<tr>
<td style="text-align:left">25</td>
<td style="text-align:left">RESUMENEWNAME</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">200</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">简历新文件名</td>
</tr>
<tr>
<td style="text-align:left">26</td>
<td style="text-align:left">RESUMETYPE</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">200</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">简历格式</td>
</tr>
<tr>
<td style="text-align:left">27</td>
<td style="text-align:left">HuJiSuoZaiDi</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">200</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">户籍所在地，编码（关联至TBCode_Area的CodeValue）</td>
</tr>
<tr>
<td style="text-align:left">28</td>
<td style="text-align:left">HUJIPAICHUSUO</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">200</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">户籍所在派出所</td>
</tr>
<tr>
<td style="text-align:left">29</td>
<td style="text-align:left">WORKDATE</td>
<td style="text-align:left">datetime</td>
<td style="text-align:left">8</td>
<td style="text-align:left">3</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">工作时间</td>
</tr>
<tr>
<td style="text-align:left">30</td>
<td style="text-align:left">JINRUDATE</td>
<td style="text-align:left">datetime</td>
<td style="text-align:left">8</td>
<td style="text-align:left">3</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">加入公司时间</td>
</tr>
<tr>
<td style="text-align:left">31</td>
<td style="text-align:left">CARNUMBER</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">200</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">车牌号</td>
</tr>
<tr>
<td style="text-align:left">32</td>
<td style="text-align:left">QQ</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">15</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">QQ号</td>
</tr>
<tr>
<td style="text-align:left">33</td>
<td style="text-align:left">WEBCHATOPENID</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">200</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">微信公众账号对应的OpenID</td>
</tr>
<tr>
<td style="text-align:left">34</td>
<td style="text-align:left">CREATEDATE</td>
<td style="text-align:left">datetime</td>
<td style="text-align:left">8</td>
<td style="text-align:left">3</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">创建时间</td>
</tr>
<tr>
<td style="text-align:left">35</td>
<td style="text-align:left">CREATEUSER</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">36</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">创建者</td>
</tr>
<tr>
<td style="text-align:left">36</td>
<td style="text-align:left">UPDATEDATE</td>
<td style="text-align:left">datetime</td>
<td style="text-align:left">8</td>
<td style="text-align:left">3</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">修改时间</td>
</tr>
<tr>
<td style="text-align:left">37</td>
<td style="text-align:left">UPDATEUSER</td>
<td style="text-align:left">nvarchar</td>
<td style="text-align:left">36</td>
<td style="text-align:left">0</td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left"></td>
<td style="text-align:left">是</td>
<td style="text-align:left">修改者</td>
</tr>
</tbody>
</table>
<p>以下是创建表的sql脚本：</p>
<figure class="highlight sql"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br><span class="line">10</span><br><span class="line">11</span><br><span class="line">12</span><br><span class="line">13</span><br><span class="line">14</span><br><span class="line">15</span><br><span class="line">16</span><br><span class="line">17</span><br><span class="line">18</span><br><span class="line">19</span><br><span class="line">20</span><br><span class="line">21</span><br><span class="line">22</span><br><span class="line">23</span><br><span class="line">24</span><br><span class="line">25</span><br><span class="line">26</span><br><span class="line">27</span><br><span class="line">28</span><br><span class="line">29</span><br><span class="line">30</span><br><span class="line">31</span><br><span class="line">32</span><br><span class="line">33</span><br><span class="line">34</span><br><span class="line">35</span><br><span class="line">36</span><br><span class="line">37</span><br><span class="line">38</span><br><span class="line">39</span><br><span class="line">40</span><br><span class="line">41</span><br><span class="line">42</span><br><span class="line">43</span><br><span class="line">44</span><br><span class="line">45</span><br><span class="line">46</span><br><span class="line">47</span><br><span class="line">48</span><br><span class="line">49</span><br><span class="line">50</span><br><span class="line">51</span><br><span class="line">52</span><br><span class="line">53</span><br><span class="line">54</span><br><span class="line">55</span><br><span class="line">56</span><br><span class="line">57</span><br><span class="line">58</span><br><span class="line">59</span><br><span class="line">60</span><br><span class="line">61</span><br><span class="line">62</span><br><span class="line">63</span><br><span class="line">64</span><br><span class="line">65</span><br><span class="line">66</span><br><span class="line">67</span><br><span class="line">68</span><br><span class="line">69</span><br><span class="line">70</span><br><span class="line">71</span><br><span class="line">72</span><br><span class="line">73</span><br><span class="line">74</span><br><span class="line">75</span><br><span class="line">76</span><br><span class="line">77</span><br><span class="line">78</span><br><span class="line">79</span><br><span class="line">80</span><br><span class="line">81</span><br><span class="line">82</span><br><span class="line">83</span><br><span class="line">84</span><br><span class="line">85</span><br><span class="line">86</span><br><span class="line">87</span><br><span class="line">88</span><br><span class="line">89</span><br><span class="line">90</span><br><span class="line">91</span><br><span class="line">92</span><br><span class="line">93</span><br><span class="line">94</span><br><span class="line">95</span><br><span class="line">96</span><br><span class="line">97</span><br><span class="line">98</span><br><span class="line">99</span><br><span class="line">100</span><br><span class="line">101</span><br><span class="line">102</span><br><span class="line">103</span><br><span class="line">104</span><br><span class="line">105</span><br><span class="line">106</span><br><span class="line">107</span><br><span class="line">108</span><br><span class="line">109</span><br><span class="line">110</span><br><span class="line">111</span><br><span class="line">112</span><br><span class="line">113</span><br><span class="line">114</span><br><span class="line">115</span><br><span class="line">116</span><br><span class="line">117</span><br><span class="line">118</span><br><span class="line">119</span><br><span class="line">120</span><br><span class="line">121</span><br><span class="line">122</span><br><span class="line">123</span><br><span class="line">124</span><br><span class="line">125</span><br><span class="line">126</span><br><span class="line">127</span><br><span class="line">128</span><br><span class="line">129</span><br><span class="line">130</span><br><span class="line">131</span><br><span class="line">132</span><br><span class="line">133</span><br><span class="line">134</span><br><span class="line">135</span><br><span class="line">136</span><br><span class="line">137</span><br><span class="line">138</span><br><span class="line">139</span><br><span class="line">140</span><br><span class="line">141</span><br><span class="line">142</span><br><span class="line">143</span><br><span class="line">144</span><br><span class="line">145</span><br><span class="line">146</span><br><span class="line">147</span><br><span class="line">148</span><br><span class="line">149</span><br><span class="line">150</span><br><span class="line">151</span><br><span class="line">152</span><br><span class="line">153</span><br><span class="line">154</span><br><span class="line">155</span><br><span class="line">156</span><br><span class="line">157</span><br><span class="line">158</span><br><span class="line">159</span><br><span class="line">160</span><br><span class="line">161</span><br><span class="line">162</span><br><span class="line">163</span><br><span class="line">164</span><br><span class="line">165</span><br><span class="line">166</span><br><span class="line">167</span><br><span class="line">168</span><br><span class="line">169</span><br><span class="line">170</span><br><span class="line">171</span><br><span class="line">172</span><br><span class="line">173</span><br><span class="line">174</span><br><span class="line">175</span><br><span class="line">176</span><br><span class="line">177</span><br><span class="line">178</span><br><span class="line">179</span><br><span class="line">180</span><br><span class="line">181</span><br><span class="line">182</span><br><span class="line">183</span><br><span class="line">184</span><br><span class="line">185</span><br><span class="line">186</span><br><span class="line">187</span><br><span class="line">188</span><br><span class="line">189</span><br><span class="line">190</span><br><span class="line">191</span><br><span class="line">192</span><br><span class="line">193</span><br><span class="line">194</span><br><span class="line">195</span><br><span class="line">196</span><br><span class="line">197</span><br><span class="line">198</span><br><span class="line">199</span><br><span class="line">200</span><br><span class="line">201</span><br><span class="line">202</span><br><span class="line">203</span><br><span class="line">204</span><br><span class="line">205</span><br><span class="line">206</span><br><span class="line">207</span><br><span class="line">208</span><br><span class="line">209</span><br><span class="line">210</span><br><span class="line">211</span><br><span class="line">212</span><br><span class="line">213</span><br><span class="line">214</span><br><span class="line">215</span><br><span class="line">216</span><br><span class="line">217</span><br><span class="line">218</span><br><span class="line">219</span><br><span class="line">220</span><br><span class="line">221</span><br><span class="line">222</span><br><span class="line">223</span><br><span class="line">224</span><br><span class="line">225</span><br><span class="line">226</span><br><span class="line">227</span><br><span class="line">228</span><br><span class="line">229</span><br><span class="line">230</span><br><span class="line">231</span><br><span class="line">232</span><br><span class="line">233</span><br><span class="line">234</span><br><span class="line">235</span><br><span class="line">236</span><br><span class="line">237</span><br><span class="line">238</span><br><span class="line">239</span><br><span class="line">240</span><br><span class="line">241</span><br><span class="line">242</span><br><span class="line">243</span><br><span class="line">244</span><br><span class="line">245</span><br><span class="line">246</span><br><span class="line">247</span><br><span class="line">248</span><br><span class="line">249</span><br><span class="line">250</span><br><span class="line">251</span><br><span class="line">252</span><br><span class="line">253</span><br><span class="line">254</span><br><span class="line">255</span><br><span class="line">256</span><br><span class="line">257</span><br><span class="line">258</span><br><span class="line">259</span><br><span class="line">260</span><br><span class="line">261</span><br><span class="line">262</span><br><span class="line">263</span><br><span class="line">264</span><br><span class="line">265</span><br><span class="line">266</span><br><span class="line">267</span><br><span class="line">268</span><br><span class="line">269</span><br><span class="line">270</span><br><span class="line">271</span><br><span class="line">272</span><br><span class="line">273</span><br><span class="line">274</span><br><span class="line">275</span><br><span class="line">276</span><br><span class="line">277</span><br><span class="line">278</span><br><span class="line">279</span><br><span class="line">280</span><br><span class="line">281</span><br><span class="line">282</span><br><span class="line">283</span><br><span class="line">284</span><br><span class="line">285</span><br><span class="line">286</span><br><span class="line">287</span><br><span class="line">288</span><br><span class="line">289</span><br><span class="line">290</span><br><span class="line">291</span><br><span class="line">292</span><br><span class="line">293</span><br><span class="line">294</span><br><span class="line">295</span><br><span class="line">296</span><br><span class="line">297</span><br><span class="line">298</span><br><span class="line">299</span><br><span class="line">300</span><br><span class="line">301</span><br><span class="line">302</span><br><span class="line">303</span><br><span class="line">304</span><br><span class="line">305</span><br><span class="line">306</span><br><span class="line">307</span><br><span class="line">308</span><br><span class="line">309</span><br><span class="line">310</span><br><span class="line">311</span><br><span class="line">312</span><br><span class="line">313</span><br><span class="line">314</span><br><span class="line">315</span><br><span class="line">316</span><br><span class="line">317</span><br><span class="line">318</span><br><span class="line">319</span><br><span class="line">320</span><br><span class="line">321</span><br><span class="line">322</span><br><span class="line">323</span><br><span class="line">324</span><br><span class="line">325</span><br><span class="line">326</span><br><span class="line">327</span><br><span class="line">328</span><br><span class="line">329</span><br><span class="line">330</span><br><span class="line">331</span><br><span class="line">332</span><br><span class="line">333</span><br><span class="line">334</span><br><span class="line">335</span><br><span class="line">336</span><br><span class="line">337</span><br><span class="line">338</span><br><span class="line">339</span><br><span class="line">340</span><br><span class="line">341</span><br><span class="line">342</span><br><span class="line">343</span><br><span class="line">344</span><br><span class="line">345</span><br><span class="line">346</span><br><span class="line">347</span><br><span class="line">348</span><br><span class="line">349</span><br><span class="line">350</span><br><span class="line">351</span><br><span class="line">352</span><br><span class="line">353</span><br><span class="line">354</span><br><span class="line">355</span><br><span class="line">356</span><br><span class="line">357</span><br><span class="line">358</span><br><span class="line">359</span><br><span class="line">360</span><br><span class="line">361</span><br><span class="line">362</span><br><span class="line">363</span><br><span class="line">364</span><br><span class="line">365</span><br><span class="line">366</span><br><span class="line">367</span><br><span class="line">368</span><br><span class="line">369</span><br><span class="line">370</span><br><span class="line">371</span><br><span class="line">372</span><br><span class="line">373</span><br><span class="line">374</span><br><span class="line">375</span><br><span class="line">376</span><br><span class="line">377</span><br><span class="line">378</span><br><span class="line">379</span><br><span class="line">380</span><br><span class="line">381</span><br><span class="line">382</span><br><span class="line">383</span><br><span class="line">384</span><br><span class="line">385</span><br><span class="line">386</span><br><span class="line">387</span><br><span class="line">388</span><br><span class="line">389</span><br><span class="line">390</span><br><span class="line">391</span><br><span class="line">392</span><br><span class="line">393</span><br><span class="line">394</span><br><span class="line">395</span><br><span class="line">396</span><br><span class="line">397</span><br><span class="line">398</span><br><span class="line">399</span><br><span class="line">400</span><br><span class="line">401</span><br><span class="line">402</span><br><span class="line">403</span><br><span class="line">404</span><br><span class="line">405</span><br><span class="line">406</span><br><span class="line">407</span><br><span class="line">408</span><br><span class="line">409</span><br><span class="line">410</span><br><span class="line">411</span><br><span class="line">412</span><br><span class="line">413</span><br><span class="line">414</span><br><span class="line">415</span><br><span class="line">416</span><br><span class="line">417</span><br><span class="line">418</span><br><span class="line">419</span><br><span class="line">420</span><br><span class="line">421</span><br><span class="line">422</span><br><span class="line">423</span><br><span class="line">424</span><br><span class="line">425</span><br><span class="line">426</span><br><span class="line">427</span><br><span class="line">428</span><br><span class="line">429</span><br><span class="line">430</span><br><span class="line">431</span><br><span class="line">432</span><br><span class="line">433</span><br><span class="line">434</span><br><span class="line">435</span><br><span class="line">436</span><br><span class="line">437</span><br><span class="line">438</span><br><span class="line">439</span><br><span class="line">440</span><br><span class="line">441</span><br><span class="line">442</span><br><span class="line">443</span><br><span class="line">444</span><br><span class="line">445</span><br><span class="line">446</span><br><span class="line">447</span><br><span class="line">448</span><br><span class="line">449</span><br><span class="line">450</span><br><span class="line">451</span><br><span class="line">452</span><br><span class="line">453</span><br><span class="line">454</span><br><span class="line">455</span><br><span class="line">456</span><br><span class="line">457</span><br><span class="line">458</span><br><span class="line">459</span><br><span class="line">460</span><br><span class="line">461</span><br><span class="line">462</span><br><span class="line">463</span><br><span class="line">464</span><br><span class="line">465</span><br><span class="line">466</span><br><span class="line">467</span><br><span class="line">468</span><br><span class="line">469</span><br><span class="line">470</span><br><span class="line">471</span><br><span class="line">472</span><br><span class="line">473</span><br><span class="line">474</span><br><span class="line">475</span><br><span class="line">476</span><br><span class="line">477</span><br><span class="line">478</span><br><span class="line">479</span><br><span class="line">480</span><br><span class="line">481</span><br><span class="line">482</span><br><span class="line">483</span><br><span class="line">484</span><br><span class="line">485</span><br><span class="line">486</span><br><span class="line">487</span><br><span class="line">488</span><br><span class="line">489</span><br><span class="line">490</span><br><span class="line">491</span><br><span class="line">492</span><br><span class="line">493</span><br><span class="line">494</span><br><span class="line">495</span><br><span class="line">496</span><br><span class="line">497</span><br><span class="line">498</span><br><span class="line">499</span><br><span class="line">500</span><br><span class="line">501</span><br><span class="line">502</span><br><span class="line">503</span><br><span class="line">504</span><br><span class="line">505</span><br><span class="line">506</span><br><span class="line">507</span><br><span class="line">508</span><br><span class="line">509</span><br><span class="line">510</span><br><span class="line">511</span><br><span class="line">512</span><br><span class="line">513</span><br><span class="line">514</span><br><span class="line">515</span><br><span class="line">516</span><br><span class="line">517</span><br><span class="line">518</span><br><span class="line">519</span><br><span class="line">520</span><br><span class="line">521</span><br><span class="line">522</span><br><span class="line">523</span><br><span class="line">524</span><br><span class="line">525</span><br><span class="line">526</span><br><span class="line">527</span><br><span class="line">528</span><br><span class="line">529</span><br><span class="line">530</span><br><span class="line">531</span><br><span class="line">532</span><br><span class="line">533</span><br><span class="line">534</span><br><span class="line">535</span><br><span class="line">536</span><br><span class="line">537</span><br><span class="line">538</span><br><span class="line">539</span><br><span class="line">540</span><br><span class="line">541</span><br><span class="line">542</span><br><span class="line">543</span><br><span class="line">544</span><br><span class="line">545</span><br><span class="line">546</span><br><span class="line">547</span><br><span class="line">548</span><br><span class="line">549</span><br><span class="line">550</span><br><span class="line">551</span><br><span class="line">552</span><br><span class="line">553</span><br><span class="line">554</span><br><span class="line">555</span><br><span class="line">556</span><br><span class="line">557</span><br><span class="line">558</span><br><span class="line">559</span><br><span class="line">560</span><br><span class="line">561</span><br><span class="line">562</span><br><span class="line">563</span><br><span class="line">564</span><br><span class="line">565</span><br><span class="line">566</span><br><span class="line">567</span><br><span class="line">568</span><br><span class="line">569</span><br><span class="line">570</span><br><span class="line">571</span><br><span class="line">572</span><br><span class="line">573</span><br><span class="line">574</span><br><span class="line">575</span><br><span class="line">576</span><br><span class="line">577</span><br><span class="line">578</span><br><span class="line">579</span><br><span class="line">580</span><br><span class="line">581</span><br><span class="line">582</span><br><span class="line">583</span><br><span class="line">584</span><br><span class="line">585</span><br><span class="line">586</span><br><span class="line">587</span><br><span class="line">588</span><br><span class="line">589</span><br><span class="line">590</span><br><span class="line">591</span><br><span class="line">592</span><br><span class="line">593</span><br><span class="line">594</span><br><span class="line">595</span><br><span class="line">596</span><br><span class="line">597</span><br><span class="line">598</span><br><span class="line">599</span><br><span class="line">600</span><br><span class="line">601</span><br><span class="line">602</span><br><span class="line">603</span><br><span class="line">604</span><br><span class="line">605</span><br><span class="line">606</span><br><span class="line">607</span><br><span class="line">608</span><br><span class="line">609</span><br><span class="line">610</span><br><span class="line">611</span><br><span class="line">612</span><br><span class="line">613</span><br><span class="line">614</span><br><span class="line">615</span><br><span class="line">616</span><br><span class="line">617</span><br><span class="line">618</span><br><span class="line">619</span><br><span class="line">620</span><br><span class="line">621</span><br><span class="line">622</span><br><span class="line">623</span><br><span class="line">624</span><br><span class="line">625</span><br><span class="line">626</span><br><span class="line">627</span><br><span class="line">628</span><br><span class="line">629</span><br><span class="line">630</span><br><span class="line">631</span><br><span class="line">632</span><br><span class="line">633</span><br><span class="line">634</span><br><span class="line">635</span><br><span class="line">636</span><br><span class="line">637</span><br><span class="line">638</span><br><span class="line">639</span><br><span class="line">640</span><br><span class="line">641</span><br><span class="line">642</span><br><span class="line">643</span><br><span class="line">644</span><br><span class="line">645</span><br><span class="line">646</span><br><span class="line">647</span><br><span class="line">648</span><br><span class="line">649</span><br><span class="line">650</span><br><span class="line">651</span><br><span class="line">652</span><br><span class="line">653</span><br><span class="line">654</span><br><span class="line">655</span><br><span class="line">656</span><br></pre></td><td class="code"><pre><span class="line"><span class="keyword">USE</span> [wkmvc_db]</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> ANSI_NULLS <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> QUOTED_IDENTIFIER <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">CREATE</span> <span class="keyword">TABLE</span> [dbo].[SYS_CODE](</span><br><span class="line">    [<span class="keyword">ID</span>] [<span class="built_in">int</span>] <span class="keyword">IDENTITY</span>(<span class="number">1</span>,<span class="number">1</span>) <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [CODETYPE] [<span class="keyword">nvarchar</span>](<span class="number">50</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [NAMETEXT] [<span class="keyword">nvarchar</span>](<span class="number">200</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [CODEVALUE] [<span class="keyword">nvarchar</span>](<span class="number">100</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [SHOWORDER] [<span class="built_in">int</span>] <span class="literal">NULL</span>,</span><br><span class="line">    [ISCODE] [<span class="built_in">int</span>] <span class="literal">NULL</span>,</span><br><span class="line">    [REMARK] [<span class="keyword">nvarchar</span>](<span class="number">2000</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [CREATEDATE] [datetime] <span class="literal">NULL</span>,</span><br><span class="line">    [CREATEUSER] [<span class="keyword">nvarchar</span>](<span class="number">36</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [UPDATEDATE] [datetime] <span class="literal">NULL</span>,</span><br><span class="line">    [UPDATEUSER] [<span class="keyword">nvarchar</span>](<span class="number">36</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [PARENTID] [<span class="built_in">int</span>] <span class="literal">NULL</span>,</span><br><span class="line"> <span class="keyword">CONSTRAINT</span> [PK_SYS_CODE] PRIMARY <span class="keyword">KEY</span> CLUSTERED</span><br><span class="line">(</span><br><span class="line">    [<span class="keyword">ID</span>] <span class="keyword">ASC</span></span><br><span class="line">)<span class="keyword">WITH</span> (PAD_INDEX = <span class="keyword">OFF</span>, STATISTICS_NORECOMPUTE = <span class="keyword">OFF</span>, IGNORE_DUP_KEY = <span class="keyword">OFF</span>, ALLOW_ROW_LOCKS = <span class="keyword">ON</span>, ALLOW_PAGE_LOCKS = <span class="keyword">ON</span>) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line">) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line"></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> ANSI_NULLS <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> QUOTED_IDENTIFIER <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> ANSI_PADDING <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">CREATE</span> <span class="keyword">TABLE</span> [dbo].[SYS_CODE_AREA](</span><br><span class="line">    [<span class="keyword">ID</span>] [<span class="built_in">varchar</span>](<span class="number">50</span>) <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [PID] [<span class="built_in">varchar</span>](<span class="number">50</span>) <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [<span class="keyword">NAME</span>] [<span class="keyword">nvarchar</span>](<span class="number">200</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [<span class="keyword">LEVELS</span>] [tinyint] <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line"> <span class="keyword">CONSTRAINT</span> [PK_SYS_CODE_AREA] PRIMARY <span class="keyword">KEY</span> CLUSTERED</span><br><span class="line">(</span><br><span class="line">    [<span class="keyword">ID</span>] <span class="keyword">ASC</span></span><br><span class="line">)<span class="keyword">WITH</span> (PAD_INDEX = <span class="keyword">OFF</span>, STATISTICS_NORECOMPUTE = <span class="keyword">OFF</span>, IGNORE_DUP_KEY = <span class="keyword">OFF</span>, ALLOW_ROW_LOCKS = <span class="keyword">ON</span>, ALLOW_PAGE_LOCKS = <span class="keyword">ON</span>) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line">) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line"></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> ANSI_PADDING <span class="keyword">OFF</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> ANSI_NULLS <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> QUOTED_IDENTIFIER <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">CREATE</span> <span class="keyword">TABLE</span> [dbo].[SYS_DEPARTMENT](</span><br><span class="line">    [<span class="keyword">ID</span>] [<span class="keyword">nvarchar</span>](<span class="number">36</span>) <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [CODE] [<span class="keyword">nvarchar</span>](<span class="number">100</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [<span class="keyword">NAME</span>] [<span class="keyword">nvarchar</span>](<span class="number">200</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [BUSINESSLEVEL] [<span class="built_in">int</span>] <span class="literal">NULL</span>,</span><br><span class="line">    [SHOWORDER] [<span class="built_in">int</span>] <span class="literal">NULL</span>,</span><br><span class="line">    [CREATEPERID] [<span class="keyword">nvarchar</span>](<span class="number">36</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [CREATEDATE] [<span class="built_in">date</span>] <span class="literal">NULL</span>,</span><br><span class="line">    [PARENTID] [<span class="keyword">nvarchar</span>](<span class="number">36</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [UPDATEDATE] [<span class="built_in">date</span>] <span class="literal">NULL</span>,</span><br><span class="line">    [UPDATEUSER] [<span class="keyword">nvarchar</span>](<span class="number">36</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [PARENTCODE] [<span class="keyword">nvarchar</span>](<span class="number">100</span>) <span class="literal">NULL</span>,</span><br><span class="line"> <span class="keyword">CONSTRAINT</span> [PK_SYS_DEPARTMENT] PRIMARY <span class="keyword">KEY</span> CLUSTERED</span><br><span class="line">(</span><br><span class="line">    [<span class="keyword">ID</span>] <span class="keyword">ASC</span></span><br><span class="line">)<span class="keyword">WITH</span> (PAD_INDEX = <span class="keyword">OFF</span>, STATISTICS_NORECOMPUTE = <span class="keyword">OFF</span>, IGNORE_DUP_KEY = <span class="keyword">OFF</span>, ALLOW_ROW_LOCKS = <span class="keyword">ON</span>, ALLOW_PAGE_LOCKS = <span class="keyword">ON</span>) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line">) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line"></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> ANSI_NULLS <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> QUOTED_IDENTIFIER <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">CREATE</span> <span class="keyword">TABLE</span> [dbo].[SYS_MODULE](</span><br><span class="line">    [<span class="keyword">ID</span>] [<span class="built_in">int</span>] <span class="keyword">IDENTITY</span>(<span class="number">1</span>,<span class="number">1</span>) <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [FK_BELONGSYSTEM] [<span class="keyword">nvarchar</span>](<span class="number">36</span>) <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [PARENTID] [<span class="built_in">int</span>] <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [<span class="keyword">NAME</span>] [<span class="keyword">nvarchar</span>](<span class="number">50</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [<span class="keyword">ALIAS</span>] [<span class="keyword">nvarchar</span>](<span class="number">50</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [MODULETYPE] [<span class="built_in">int</span>] <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [ICON] [<span class="keyword">nvarchar</span>](<span class="number">200</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [MODULEPATH] [<span class="keyword">nvarchar</span>](<span class="number">500</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [ISSHOW] [<span class="built_in">int</span>] <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [SHOWORDER] [<span class="built_in">int</span>] <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [<span class="keyword">LEVELS</span>] [<span class="built_in">int</span>] <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [IsVillage] [<span class="built_in">bit</span>] <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [CREATEUSER] [<span class="keyword">nvarchar</span>](<span class="number">50</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [CREATEDATE] [datetime] <span class="literal">NULL</span>,</span><br><span class="line">    [UPDATEUSER] [<span class="keyword">nvarchar</span>](<span class="number">36</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [UPDATEDATE] [datetime] <span class="literal">NULL</span>,</span><br><span class="line"> <span class="keyword">CONSTRAINT</span> [PK_SYS_MODULE] PRIMARY <span class="keyword">KEY</span> CLUSTERED</span><br><span class="line">(</span><br><span class="line">    [<span class="keyword">ID</span>] <span class="keyword">ASC</span></span><br><span class="line">)<span class="keyword">WITH</span> (PAD_INDEX = <span class="keyword">OFF</span>, STATISTICS_NORECOMPUTE = <span class="keyword">OFF</span>, IGNORE_DUP_KEY = <span class="keyword">OFF</span>, ALLOW_ROW_LOCKS = <span class="keyword">ON</span>, ALLOW_PAGE_LOCKS = <span class="keyword">ON</span>) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line">) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line"></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> ANSI_NULLS <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> QUOTED_IDENTIFIER <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">CREATE</span> <span class="keyword">TABLE</span> [dbo].[SYS_PERMISSION](</span><br><span class="line">    [<span class="keyword">ID</span>] [<span class="built_in">int</span>] <span class="keyword">IDENTITY</span>(<span class="number">1</span>,<span class="number">1</span>) <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [MODULEID] [<span class="built_in">int</span>] <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [<span class="keyword">NAME</span>] [<span class="keyword">nvarchar</span>](<span class="number">36</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [PERVALUE] [<span class="keyword">nvarchar</span>](<span class="number">100</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [ICON] [<span class="keyword">nvarchar</span>](<span class="number">50</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [SHOWORDER] [<span class="built_in">int</span>] <span class="literal">NULL</span>,</span><br><span class="line">    [CREATEDATE] [<span class="built_in">date</span>] <span class="literal">NULL</span>,</span><br><span class="line">    [CREATEUSER] [<span class="keyword">nvarchar</span>](<span class="number">36</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [UPDATEDATE] [<span class="built_in">date</span>] <span class="literal">NULL</span>,</span><br><span class="line">    [UPDATEUSER] [<span class="keyword">nvarchar</span>](<span class="number">36</span>) <span class="literal">NULL</span>,</span><br><span class="line"> <span class="keyword">CONSTRAINT</span> [PK_SYS_PERMISSION] PRIMARY <span class="keyword">KEY</span> CLUSTERED</span><br><span class="line">(</span><br><span class="line">    [<span class="keyword">ID</span>] <span class="keyword">ASC</span></span><br><span class="line">)<span class="keyword">WITH</span> (PAD_INDEX = <span class="keyword">OFF</span>, STATISTICS_NORECOMPUTE = <span class="keyword">OFF</span>, IGNORE_DUP_KEY = <span class="keyword">OFF</span>, ALLOW_ROW_LOCKS = <span class="keyword">ON</span>, ALLOW_PAGE_LOCKS = <span class="keyword">ON</span>) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line">) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line"></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> ANSI_NULLS <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> QUOTED_IDENTIFIER <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">CREATE</span> <span class="keyword">TABLE</span> [dbo].[SYS_POST](</span><br><span class="line">    [<span class="keyword">ID</span>] [<span class="keyword">nvarchar</span>](<span class="number">36</span>) <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [POSTNAME] [<span class="keyword">nvarchar</span>](<span class="number">100</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [POSTTYPE] [<span class="keyword">nvarchar</span>](<span class="number">36</span>) <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [REMARK] [<span class="keyword">nvarchar</span>](<span class="number">500</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [SHOWORDER] [<span class="built_in">int</span>] <span class="literal">NULL</span>,</span><br><span class="line">    [CREATEUSERID] [<span class="built_in">int</span>] <span class="literal">NULL</span>,</span><br><span class="line">    [CREATEDATE] [datetime] <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [UPDATEDATE] [datetime] <span class="literal">NULL</span>,</span><br><span class="line">    [UPDATEUSER] [<span class="keyword">nvarchar</span>](<span class="number">36</span>) <span class="literal">NULL</span>,</span><br><span class="line"> <span class="keyword">CONSTRAINT</span> [PK_SYS_POST] PRIMARY <span class="keyword">KEY</span> CLUSTERED</span><br><span class="line">(</span><br><span class="line">    [<span class="keyword">ID</span>] <span class="keyword">ASC</span></span><br><span class="line">)<span class="keyword">WITH</span> (PAD_INDEX = <span class="keyword">OFF</span>, STATISTICS_NORECOMPUTE = <span class="keyword">OFF</span>, IGNORE_DUP_KEY = <span class="keyword">OFF</span>, ALLOW_ROW_LOCKS = <span class="keyword">ON</span>, ALLOW_PAGE_LOCKS = <span class="keyword">ON</span>) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line">) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line"></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> ANSI_NULLS <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> QUOTED_IDENTIFIER <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">CREATE</span> <span class="keyword">TABLE</span> [dbo].[SYS_POST_DEPARTMENT](</span><br><span class="line">    [<span class="keyword">ID</span>] [<span class="built_in">int</span>] <span class="keyword">IDENTITY</span>(<span class="number">1</span>,<span class="number">1</span>) <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [FK_DEPARTMENT_ID] [<span class="keyword">nvarchar</span>](<span class="number">36</span>) <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [FK_POST_ID] [<span class="keyword">nvarchar</span>](<span class="number">36</span>) <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line"> <span class="keyword">CONSTRAINT</span> [PK_SYS_POST_DEPARTMENT] PRIMARY <span class="keyword">KEY</span> CLUSTERED</span><br><span class="line">(</span><br><span class="line">    [<span class="keyword">ID</span>] <span class="keyword">ASC</span></span><br><span class="line">)<span class="keyword">WITH</span> (PAD_INDEX = <span class="keyword">OFF</span>, STATISTICS_NORECOMPUTE = <span class="keyword">OFF</span>, IGNORE_DUP_KEY = <span class="keyword">OFF</span>, ALLOW_ROW_LOCKS = <span class="keyword">ON</span>, ALLOW_PAGE_LOCKS = <span class="keyword">ON</span>) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line">) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line"></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> ANSI_NULLS <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> QUOTED_IDENTIFIER <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">CREATE</span> <span class="keyword">TABLE</span> [dbo].[SYS_POST_USER](</span><br><span class="line">    [<span class="keyword">ID</span>] [<span class="built_in">int</span>] <span class="keyword">IDENTITY</span>(<span class="number">1</span>,<span class="number">1</span>) <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [FK_USERID] [<span class="built_in">int</span>] <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [FK_POST_DEPARTMENTID] [<span class="built_in">int</span>] <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line"> <span class="keyword">CONSTRAINT</span> [PK_SYS_POST_USER] PRIMARY <span class="keyword">KEY</span> CLUSTERED</span><br><span class="line">(</span><br><span class="line">    [<span class="keyword">ID</span>] <span class="keyword">ASC</span></span><br><span class="line">)<span class="keyword">WITH</span> (PAD_INDEX = <span class="keyword">OFF</span>, STATISTICS_NORECOMPUTE = <span class="keyword">OFF</span>, IGNORE_DUP_KEY = <span class="keyword">OFF</span>, ALLOW_ROW_LOCKS = <span class="keyword">ON</span>, ALLOW_PAGE_LOCKS = <span class="keyword">ON</span>) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line">) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line"></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> ANSI_NULLS <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> QUOTED_IDENTIFIER <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">CREATE</span> <span class="keyword">TABLE</span> [dbo].[SYS_ROLE](</span><br><span class="line">    [<span class="keyword">ID</span>] [<span class="built_in">int</span>] <span class="keyword">IDENTITY</span>(<span class="number">1</span>,<span class="number">1</span>) <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [ROLENAME] [<span class="keyword">nvarchar</span>](<span class="number">50</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [ISCUSTOM] [<span class="built_in">int</span>] <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [ROLEDESC] [<span class="keyword">nvarchar</span>](<span class="number">1000</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [CREATEPERID] [<span class="keyword">nvarchar</span>](<span class="number">36</span>) <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [CREATEDATE] [datetime] <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [UPDATEDATE] [datetime] <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [UPDATEUSER] [<span class="keyword">nvarchar</span>](<span class="number">36</span>) <span class="literal">NULL</span>,</span><br><span class="line"> <span class="keyword">CONSTRAINT</span> [PK_SYS_ROLE] PRIMARY <span class="keyword">KEY</span> CLUSTERED</span><br><span class="line">(</span><br><span class="line">    [<span class="keyword">ID</span>] <span class="keyword">ASC</span></span><br><span class="line">)<span class="keyword">WITH</span> (PAD_INDEX = <span class="keyword">OFF</span>, STATISTICS_NORECOMPUTE = <span class="keyword">OFF</span>, IGNORE_DUP_KEY = <span class="keyword">OFF</span>, ALLOW_ROW_LOCKS = <span class="keyword">ON</span>, ALLOW_PAGE_LOCKS = <span class="keyword">ON</span>) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line">) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line"></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> ANSI_NULLS <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> QUOTED_IDENTIFIER <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">CREATE</span> <span class="keyword">TABLE</span> [dbo].[SYS_ROLE_PERMISSION](</span><br><span class="line">    [<span class="keyword">ID</span>] [<span class="built_in">int</span>] <span class="keyword">IDENTITY</span>(<span class="number">1</span>,<span class="number">1</span>) <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [ROLEID] [<span class="built_in">int</span>] <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [PERMISSIONID] [<span class="built_in">int</span>] <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line"> <span class="keyword">CONSTRAINT</span> [PK_SYS_ROLE_PERMISSION] PRIMARY <span class="keyword">KEY</span> CLUSTERED</span><br><span class="line">(</span><br><span class="line">    [<span class="keyword">ID</span>] <span class="keyword">ASC</span></span><br><span class="line">)<span class="keyword">WITH</span> (PAD_INDEX = <span class="keyword">OFF</span>, STATISTICS_NORECOMPUTE = <span class="keyword">OFF</span>, IGNORE_DUP_KEY = <span class="keyword">OFF</span>, ALLOW_ROW_LOCKS = <span class="keyword">ON</span>, ALLOW_PAGE_LOCKS = <span class="keyword">ON</span>) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line">) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line"></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> ANSI_NULLS <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> QUOTED_IDENTIFIER <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">CREATE</span> <span class="keyword">TABLE</span> [dbo].[SYS_SYSTEM](</span><br><span class="line">    [<span class="keyword">ID</span>] [<span class="keyword">nvarchar</span>](<span class="number">36</span>) <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [<span class="keyword">NAME</span>] [<span class="keyword">nvarchar</span>](<span class="number">200</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [SITEURL] [<span class="keyword">nvarchar</span>](<span class="number">500</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [IS_LOGIN] [tinyint] <span class="literal">NULL</span>,</span><br><span class="line">    [DOCKUSER] [<span class="keyword">nvarchar</span>](<span class="number">100</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [DOCKPASS] [<span class="keyword">nvarchar</span>](<span class="number">200</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [CREATEDATE] [<span class="built_in">date</span>] <span class="literal">NULL</span>,</span><br><span class="line">    [REMARK] [<span class="keyword">nvarchar</span>](<span class="number">2000</span>) <span class="literal">NULL</span>,</span><br><span class="line"> <span class="keyword">CONSTRAINT</span> [PK_SYS_SYSTEM] PRIMARY <span class="keyword">KEY</span> CLUSTERED</span><br><span class="line">(</span><br><span class="line">    [<span class="keyword">ID</span>] <span class="keyword">ASC</span></span><br><span class="line">)<span class="keyword">WITH</span> (PAD_INDEX = <span class="keyword">OFF</span>, STATISTICS_NORECOMPUTE = <span class="keyword">OFF</span>, IGNORE_DUP_KEY = <span class="keyword">OFF</span>, ALLOW_ROW_LOCKS = <span class="keyword">ON</span>, ALLOW_PAGE_LOCKS = <span class="keyword">ON</span>) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line">) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line"></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> ANSI_NULLS <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> QUOTED_IDENTIFIER <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">CREATE</span> <span class="keyword">TABLE</span> [dbo].[SYS_USER_DEPARTMENT](</span><br><span class="line">    [<span class="keyword">ID</span>] [<span class="built_in">int</span>] <span class="keyword">IDENTITY</span>(<span class="number">1</span>,<span class="number">1</span>) <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [USER_ID] [<span class="built_in">int</span>] <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [DEPARTMENT_ID] [<span class="keyword">nvarchar</span>](<span class="number">36</span>) <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line"> <span class="keyword">CONSTRAINT</span> [PK_SYS_USER_DEPARTMENT] PRIMARY <span class="keyword">KEY</span> CLUSTERED</span><br><span class="line">(</span><br><span class="line">    [<span class="keyword">ID</span>] <span class="keyword">ASC</span></span><br><span class="line">)<span class="keyword">WITH</span> (PAD_INDEX = <span class="keyword">OFF</span>, STATISTICS_NORECOMPUTE = <span class="keyword">OFF</span>, IGNORE_DUP_KEY = <span class="keyword">OFF</span>, ALLOW_ROW_LOCKS = <span class="keyword">ON</span>, ALLOW_PAGE_LOCKS = <span class="keyword">ON</span>) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line">) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line"></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> ANSI_NULLS <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> QUOTED_IDENTIFIER <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">CREATE</span> <span class="keyword">TABLE</span> [dbo].[SYS_USER_PERMISSION](</span><br><span class="line">    [<span class="keyword">ID</span>] [<span class="built_in">int</span>] <span class="keyword">IDENTITY</span>(<span class="number">1</span>,<span class="number">1</span>) <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [FK_USERID] [<span class="built_in">int</span>] <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [FK_PERMISSIONID] [<span class="built_in">int</span>] <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line"> <span class="keyword">CONSTRAINT</span> [PK_SYS_USER_PERMISSION] PRIMARY <span class="keyword">KEY</span> CLUSTERED</span><br><span class="line">(</span><br><span class="line">    [<span class="keyword">ID</span>] <span class="keyword">ASC</span></span><br><span class="line">)<span class="keyword">WITH</span> (PAD_INDEX = <span class="keyword">OFF</span>, STATISTICS_NORECOMPUTE = <span class="keyword">OFF</span>, IGNORE_DUP_KEY = <span class="keyword">OFF</span>, ALLOW_ROW_LOCKS = <span class="keyword">ON</span>, ALLOW_PAGE_LOCKS = <span class="keyword">ON</span>) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line">) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line"></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> ANSI_NULLS <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> QUOTED_IDENTIFIER <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">CREATE</span> <span class="keyword">TABLE</span> [dbo].[SYS_USER_ROLE](</span><br><span class="line">    [<span class="keyword">ID</span>] [<span class="built_in">int</span>] <span class="keyword">IDENTITY</span>(<span class="number">1</span>,<span class="number">1</span>) <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [FK_USERID] [<span class="built_in">int</span>] <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [FK_ROLEID] [<span class="built_in">int</span>] <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line"> <span class="keyword">CONSTRAINT</span> [PK_SYS_USER_ROLE] PRIMARY <span class="keyword">KEY</span> CLUSTERED</span><br><span class="line">(</span><br><span class="line">    [<span class="keyword">ID</span>] <span class="keyword">ASC</span></span><br><span class="line">)<span class="keyword">WITH</span> (PAD_INDEX = <span class="keyword">OFF</span>, STATISTICS_NORECOMPUTE = <span class="keyword">OFF</span>, IGNORE_DUP_KEY = <span class="keyword">OFF</span>, ALLOW_ROW_LOCKS = <span class="keyword">ON</span>, ALLOW_PAGE_LOCKS = <span class="keyword">ON</span>) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line">) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line"></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> ANSI_NULLS <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">SET</span> QUOTED_IDENTIFIER <span class="keyword">ON</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">CREATE</span> <span class="keyword">TABLE</span> [dbo].[SYS_USERINFO](</span><br><span class="line">    [<span class="keyword">ID</span>] [<span class="built_in">int</span>] <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [USERID] [<span class="built_in">int</span>] <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line">    [POSTCODE] [<span class="built_in">int</span>] <span class="literal">NULL</span>,</span><br><span class="line">    [PHONE] [<span class="keyword">nvarchar</span>](<span class="number">200</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [OFFICEPHONE] [<span class="keyword">nvarchar</span>](<span class="number">200</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [EMAILADDRESS] [<span class="keyword">nvarchar</span>](<span class="number">200</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [SECONDPHONE] [<span class="keyword">nvarchar</span>](<span class="number">200</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [WORKCODE] [<span class="built_in">int</span>] <span class="literal">NULL</span>,</span><br><span class="line">    [SEXCODE] [<span class="built_in">int</span>] <span class="literal">NULL</span>,</span><br><span class="line">    [BIRTHDAY] [datetime] <span class="literal">NULL</span>,</span><br><span class="line">    [NATIONCODE] [<span class="built_in">int</span>] <span class="literal">NULL</span>,</span><br><span class="line">    [IDNUMBER] [<span class="keyword">nvarchar</span>](<span class="number">18</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [MARRYCODE] [<span class="built_in">int</span>] <span class="literal">NULL</span>,</span><br><span class="line">    [IDENTITYCODE] [<span class="built_in">int</span>] <span class="literal">NULL</span>,</span><br><span class="line">    [HomeTown] [<span class="keyword">nvarchar</span>](<span class="number">200</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [ACCOUNTLOCATION] [<span class="keyword">nvarchar</span>](<span class="number">200</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [XUELI] [<span class="built_in">int</span>] <span class="literal">NULL</span>,</span><br><span class="line">    [ZHICHENG] [<span class="built_in">int</span>] <span class="literal">NULL</span>,</span><br><span class="line">    [GRADUATIONSCHOOL] [<span class="keyword">nvarchar</span>](<span class="number">200</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [SPECIALTY] [<span class="keyword">nvarchar</span>](<span class="number">200</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [PHOTOOLDNAME] [<span class="keyword">nvarchar</span>](<span class="number">200</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [PHOTONEWNAME] [<span class="keyword">nvarchar</span>](<span class="number">200</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [PHOTOTYPE] [<span class="keyword">nvarchar</span>](<span class="number">200</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [RESUMEOLDNAME] [<span class="keyword">nvarchar</span>](<span class="number">200</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [RESUMENEWNAME] [<span class="keyword">nvarchar</span>](<span class="number">200</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [RESUMETYPE] [<span class="keyword">nvarchar</span>](<span class="number">200</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [HuJiSuoZaiDi] [<span class="keyword">nvarchar</span>](<span class="number">200</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [HUJIPAICHUSUO] [<span class="keyword">nvarchar</span>](<span class="number">200</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [WORKDATE] [datetime] <span class="literal">NULL</span>,</span><br><span class="line">    [JINRUDATE] [datetime] <span class="literal">NULL</span>,</span><br><span class="line">    [CARNUMBER] [<span class="keyword">nvarchar</span>](<span class="number">200</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [QQ] [<span class="keyword">nvarchar</span>](<span class="number">15</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [WEBCHATOPENID] [<span class="keyword">nvarchar</span>](<span class="number">200</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [CREATEDATE] [datetime] <span class="literal">NULL</span>,</span><br><span class="line">    [CREATEUSER] [<span class="keyword">nvarchar</span>](<span class="number">36</span>) <span class="literal">NULL</span>,</span><br><span class="line">    [UPDATEDATE] [datetime] <span class="literal">NULL</span>,</span><br><span class="line">    [UPDATEUSER] [<span class="keyword">nvarchar</span>](<span class="number">36</span>) <span class="literal">NULL</span>,</span><br><span class="line"> <span class="keyword">CONSTRAINT</span> [PK_SYS_USERINFO] PRIMARY <span class="keyword">KEY</span> CLUSTERED</span><br><span class="line">(</span><br><span class="line">    [<span class="keyword">ID</span>] <span class="keyword">ASC</span></span><br><span class="line">)<span class="keyword">WITH</span> (PAD_INDEX = <span class="keyword">OFF</span>, STATISTICS_NORECOMPUTE = <span class="keyword">OFF</span>, IGNORE_DUP_KEY = <span class="keyword">OFF</span>, ALLOW_ROW_LOCKS = <span class="keyword">ON</span>, ALLOW_PAGE_LOCKS = <span class="keyword">ON</span>) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line">) <span class="keyword">ON</span> [PRIMARY]</span><br><span class="line"></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_MODULE]  <span class="keyword">WITH</span> <span class="keyword">CHECK</span> <span class="keyword">ADD</span>  <span class="keyword">CONSTRAINT</span> [FK_SYS_MODULE_SYSTEMID] FOREIGN <span class="keyword">KEY</span>([FK_BELONGSYSTEM])</span><br><span class="line"><span class="keyword">REFERENCES</span> [dbo].[SYS_SYSTEM] ([<span class="keyword">ID</span>])</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_MODULE] <span class="keyword">CHECK</span> <span class="keyword">CONSTRAINT</span> [FK_SYS_MODULE_SYSTEMID]</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_PERMISSION]  <span class="keyword">WITH</span> <span class="keyword">CHECK</span> <span class="keyword">ADD</span>  <span class="keyword">CONSTRAINT</span> [FK_SYS_PERMISSION_MODULEID] FOREIGN <span class="keyword">KEY</span>([MODULEID])</span><br><span class="line"><span class="keyword">REFERENCES</span> [dbo].[SYS_MODULE] ([<span class="keyword">ID</span>])</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_PERMISSION] <span class="keyword">CHECK</span> <span class="keyword">CONSTRAINT</span> [FK_SYS_PERMISSION_MODULEID]</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_POST_DEPARTMENT]  <span class="keyword">WITH</span> <span class="keyword">CHECK</span> <span class="keyword">ADD</span>  <span class="keyword">CONSTRAINT</span> [FK_SYS_POST_DEPARTMENT_DPTID] FOREIGN <span class="keyword">KEY</span>([FK_DEPARTMENT_ID])</span><br><span class="line"><span class="keyword">REFERENCES</span> [dbo].[SYS_DEPARTMENT] ([<span class="keyword">ID</span>])</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_POST_DEPARTMENT] <span class="keyword">CHECK</span> <span class="keyword">CONSTRAINT</span> [FK_SYS_POST_DEPARTMENT_DPTID]</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_POST_DEPARTMENT]  <span class="keyword">WITH</span> <span class="keyword">CHECK</span> <span class="keyword">ADD</span>  <span class="keyword">CONSTRAINT</span> [FK_SYS_POST_DEPARTMENT_POSTID] FOREIGN <span class="keyword">KEY</span>([FK_POST_ID])</span><br><span class="line"><span class="keyword">REFERENCES</span> [dbo].[SYS_POST] ([<span class="keyword">ID</span>])</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_POST_DEPARTMENT] <span class="keyword">CHECK</span> <span class="keyword">CONSTRAINT</span> [FK_SYS_POST_DEPARTMENT_POSTID]</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_POST_USER]  <span class="keyword">WITH</span> <span class="keyword">CHECK</span> <span class="keyword">ADD</span>  <span class="keyword">CONSTRAINT</span> [FK_SYS_POST_USER_POSTDPTID] FOREIGN <span class="keyword">KEY</span>([FK_POST_DEPARTMENTID])</span><br><span class="line"><span class="keyword">REFERENCES</span> [dbo].[SYS_POST_DEPARTMENT] ([<span class="keyword">ID</span>])</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_POST_USER] <span class="keyword">CHECK</span> <span class="keyword">CONSTRAINT</span> [FK_SYS_POST_USER_POSTDPTID]</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_POST_USER]  <span class="keyword">WITH</span> <span class="keyword">CHECK</span> <span class="keyword">ADD</span>  <span class="keyword">CONSTRAINT</span> [FK_SYS_POST_USER_USERID] FOREIGN <span class="keyword">KEY</span>([FK_USERID])</span><br><span class="line"><span class="keyword">REFERENCES</span> [dbo].[SYS_USER] ([<span class="keyword">ID</span>])</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_POST_USER] <span class="keyword">CHECK</span> <span class="keyword">CONSTRAINT</span> [FK_SYS_POST_USER_USERID]</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_ROLE_PERMISSION]  <span class="keyword">WITH</span> <span class="keyword">CHECK</span> <span class="keyword">ADD</span>  <span class="keyword">CONSTRAINT</span> [FK_SYS_ROLE_PERMISSION_PERID] FOREIGN <span class="keyword">KEY</span>([PERMISSIONID])</span><br><span class="line"><span class="keyword">REFERENCES</span> [dbo].[SYS_PERMISSION] ([<span class="keyword">ID</span>])</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_ROLE_PERMISSION] <span class="keyword">CHECK</span> <span class="keyword">CONSTRAINT</span> [FK_SYS_ROLE_PERMISSION_PERID]</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_ROLE_PERMISSION]  <span class="keyword">WITH</span> <span class="keyword">CHECK</span> <span class="keyword">ADD</span>  <span class="keyword">CONSTRAINT</span> [FK_SYS_ROLE_PERMISSION_ROLEID] FOREIGN <span class="keyword">KEY</span>([ROLEID])</span><br><span class="line"><span class="keyword">REFERENCES</span> [dbo].[SYS_ROLE] ([<span class="keyword">ID</span>])</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_ROLE_PERMISSION] <span class="keyword">CHECK</span> <span class="keyword">CONSTRAINT</span> [FK_SYS_ROLE_PERMISSION_ROLEID]</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_USER_DEPARTMENT]  <span class="keyword">WITH</span> <span class="keyword">CHECK</span> <span class="keyword">ADD</span>  <span class="keyword">CONSTRAINT</span> [FK_SYS_USER_DEPARTMENT_DPTID] FOREIGN <span class="keyword">KEY</span>([DEPARTMENT_ID])</span><br><span class="line"><span class="keyword">REFERENCES</span> [dbo].[SYS_DEPARTMENT] ([<span class="keyword">ID</span>])</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_USER_DEPARTMENT] <span class="keyword">CHECK</span> <span class="keyword">CONSTRAINT</span> [FK_SYS_USER_DEPARTMENT_DPTID]</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_USER_DEPARTMENT]  <span class="keyword">WITH</span> <span class="keyword">CHECK</span> <span class="keyword">ADD</span>  <span class="keyword">CONSTRAINT</span> [FK_SYS_USER_DEPARTMENT_USERID] FOREIGN <span class="keyword">KEY</span>([USER_ID])</span><br><span class="line"><span class="keyword">REFERENCES</span> [dbo].[SYS_USER] ([<span class="keyword">ID</span>])</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_USER_DEPARTMENT] <span class="keyword">CHECK</span> <span class="keyword">CONSTRAINT</span> [FK_SYS_USER_DEPARTMENT_USERID]</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_USER_PERMISSION]  <span class="keyword">WITH</span> <span class="keyword">CHECK</span> <span class="keyword">ADD</span>  <span class="keyword">CONSTRAINT</span> [FK_SYS_USER_PERMISSION_PERID] FOREIGN <span class="keyword">KEY</span>([FK_PERMISSIONID])</span><br><span class="line"><span class="keyword">REFERENCES</span> [dbo].[SYS_PERMISSION] ([<span class="keyword">ID</span>])</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_USER_PERMISSION] <span class="keyword">CHECK</span> <span class="keyword">CONSTRAINT</span> [FK_SYS_USER_PERMISSION_PERID]</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_USER_PERMISSION]  <span class="keyword">WITH</span> <span class="keyword">CHECK</span> <span class="keyword">ADD</span>  <span class="keyword">CONSTRAINT</span> [FK_SYS_USER_PERMISSION_USERID] FOREIGN <span class="keyword">KEY</span>([FK_USERID])</span><br><span class="line"><span class="keyword">REFERENCES</span> [dbo].[SYS_USER] ([<span class="keyword">ID</span>])</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_USER_PERMISSION] <span class="keyword">CHECK</span> <span class="keyword">CONSTRAINT</span> [FK_SYS_USER_PERMISSION_USERID]</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_USER_ROLE]  <span class="keyword">WITH</span> <span class="keyword">CHECK</span> <span class="keyword">ADD</span>  <span class="keyword">CONSTRAINT</span> [FK_SYS_USER_ROLE_ROLEID] FOREIGN <span class="keyword">KEY</span>([FK_ROLEID])</span><br><span class="line"><span class="keyword">REFERENCES</span> [dbo].[SYS_ROLE] ([<span class="keyword">ID</span>])</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_USER_ROLE] <span class="keyword">CHECK</span> <span class="keyword">CONSTRAINT</span> [FK_SYS_USER_ROLE_ROLEID]</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_USER_ROLE]  <span class="keyword">WITH</span> <span class="keyword">CHECK</span> <span class="keyword">ADD</span>  <span class="keyword">CONSTRAINT</span> [FK_SYS_USER_ROLE_USERID] FOREIGN <span class="keyword">KEY</span>([FK_USERID])</span><br><span class="line"><span class="keyword">REFERENCES</span> [dbo].[SYS_USER] ([<span class="keyword">ID</span>])</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_USER_ROLE] <span class="keyword">CHECK</span> <span class="keyword">CONSTRAINT</span> [FK_SYS_USER_ROLE_USERID]</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_USERINFO]  <span class="keyword">WITH</span> <span class="keyword">CHECK</span> <span class="keyword">ADD</span>  <span class="keyword">CONSTRAINT</span> [FK_SYS_USERINFO_SYSUSERID] FOREIGN <span class="keyword">KEY</span>([USERID])</span><br><span class="line"><span class="keyword">REFERENCES</span> [dbo].[SYS_USER] ([<span class="keyword">ID</span>])</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line"><span class="keyword">ALTER</span> <span class="keyword">TABLE</span> [dbo].[SYS_USERINFO] <span class="keyword">CHECK</span> <span class="keyword">CONSTRAINT</span> [FK_SYS_USERINFO_SYSUSERID]</span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'主键ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_CODE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'代码类型'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_CODE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'CODETYPE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'代码显示文本'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_CODE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'NAMETEXT'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'代码值'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_CODE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'CODEVALUE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'排序值'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_CODE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'SHOWORDER'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'是否为编码（0否1是）'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_CODE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ISCODE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'备注'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_CODE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'REMARK'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'创建时间'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_CODE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'CREATEDATE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'创建者'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_CODE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'CREATEUSER'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'修改时间'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_CODE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'UPDATEDATE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'修改者'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_CODE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'UPDATEUSER'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'父级ID（使用时注意ISCODE为0）'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_CODE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'PARENTID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_CODE_AREA'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'上级ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_CODE_AREA'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'PID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'名称'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_CODE_AREA'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'NAME'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'级别'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_CODE_AREA'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'LEVELS'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'主键ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_DEPARTMENT'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'部门编号，横向增长'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_DEPARTMENT'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'CODE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'部门名称'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_DEPARTMENT'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'NAME'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'业务等级'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_DEPARTMENT'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'BUSINESSLEVEL'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'部门排序'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_DEPARTMENT'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'SHOWORDER'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'创建者编号'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_DEPARTMENT'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'CREATEPERID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'创建时间'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_DEPARTMENT'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'CREATEDATE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'上级部门ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_DEPARTMENT'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'PARENTID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'修改时间'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_DEPARTMENT'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'UPDATEDATE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'修改人'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_DEPARTMENT'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'UPDATEUSER'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'主键ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_MODULE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'所属系统'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_MODULE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'FK_BELONGSYSTEM'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'父ID，级联'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_MODULE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'PARENTID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'显示名称'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_MODULE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'NAME'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'别名'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_MODULE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ALIAS'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'模块类型'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_MODULE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'MODULETYPE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'自定义图标'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_MODULE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ICON'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'连接路径'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_MODULE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'MODULEPATH'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'是否展示（0否1是）'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_MODULE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ISSHOW'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'排序值'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_MODULE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'SHOWORDER'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'级别'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_MODULE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'LEVELS'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'创建者'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_MODULE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'CREATEUSER'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'创建时间'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_MODULE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'CREATEDATE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'修改者'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_MODULE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'UPDATEUSER'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'修改时间'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_MODULE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'UPDATEDATE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'主键ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_PERMISSION'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'模块ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_PERMISSION'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'MODULEID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'授权名称'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_PERMISSION'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'NAME'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'权限值（对应SYS_CODE表）'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_PERMISSION'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'PERVALUE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'图标ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_PERMISSION'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ICON'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'显示排序'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_PERMISSION'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'SHOWORDER'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'创建时间'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_PERMISSION'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'CREATEDATE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'创建者'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_PERMISSION'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'CREATEUSER'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'修改时间'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_PERMISSION'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'UPDATEDATE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'修改者'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_PERMISSION'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'UPDATEUSER'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'主键ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_POST'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'岗位名称'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_POST'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'POSTNAME'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'岗位类型'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_POST'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'POSTTYPE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'岗位备注'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_POST'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'REMARK'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'排序'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_POST'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'SHOWORDER'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'创建者ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_POST'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'CREATEUSERID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'创建时间'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_POST'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'CREATEDATE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'修改时间'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_POST'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'UPDATEDATE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'修改者'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_POST'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'UPDATEUSER'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'主键ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_POST_DEPARTMENT'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'部门ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_POST_DEPARTMENT'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'FK_DEPARTMENT_ID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'岗位ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_POST_DEPARTMENT'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'FK_POST_ID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'主键ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_POST_USER'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'用户ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_POST_USER'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'FK_USERID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'岗位部门ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_POST_USER'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'FK_POST_DEPARTMENTID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'主键ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_ROLE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'角色名称'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_ROLE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ROLENAME'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'是否自定义（0否1是）'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_ROLE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ISCUSTOM'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'角色说明'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_ROLE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ROLEDESC'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'创建者ID（关联SYS_USER的ID）'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_ROLE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'CREATEPERID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'创建时间'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_ROLE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'CREATEDATE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'修改时间'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_ROLE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'UPDATEDATE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'修改者'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_ROLE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'UPDATEUSER'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'主键ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_ROLE_PERMISSION'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'角色ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_ROLE_PERMISSION'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ROLEID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'授权ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_ROLE_PERMISSION'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'PERMISSIONID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'主键ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_SYSTEM'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'系统名称'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_SYSTEM'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'NAME'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'系统地址'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_SYSTEM'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'SITEURL'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'是否允许登录系统（0否1是）'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_SYSTEM'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'IS_LOGIN'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'系统对接用户名'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_SYSTEM'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'DOCKUSER'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'系统对接密码'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_SYSTEM'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'DOCKPASS'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'系统创建时间'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_SYSTEM'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'CREATEDATE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'备注'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_SYSTEM'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'REMARK'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'主键ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USER_DEPARTMENT'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'用户ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USER_DEPARTMENT'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'USER_ID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'部门ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USER_DEPARTMENT'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'DEPARTMENT_ID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'主键ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USER_PERMISSION'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'用户ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USER_PERMISSION'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'FK_USERID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'授权ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USER_PERMISSION'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'FK_PERMISSIONID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'主键ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USER_ROLE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'用户ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USER_ROLE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'FK_USERID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'角色ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USER_ROLE'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'FK_ROLEID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'主键ID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'用户ID，外键'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'USERID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'职务，编码'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'POSTCODE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'手机号码'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'PHONE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'办公电话'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'OFFICEPHONE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'Email'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'EMAILADDRESS'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'第二手机号码'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'SECONDPHONE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'在岗状态，编码'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'WORKCODE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'性别，编码'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'SEXCODE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'出生日期'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'BIRTHDAY'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'民族，编码'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'NATIONCODE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'身份证号码'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'IDNUMBER'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'婚姻状况，编码'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'MARRYCODE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'政治面貌，编码'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'IDENTITYCODE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'籍贯，编码（关联至TBCode_Area的CodeValue）'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'HomeTown'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'户籍所在地'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ACCOUNTLOCATION'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'学历，编码'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'XUELI'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'职称，编码'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'ZHICHENG'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'毕业院校'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'GRADUATIONSCHOOL'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'专业'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'SPECIALTY'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'照片原文件名'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'PHOTOOLDNAME'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'照片新文件名'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'PHOTONEWNAME'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'照片格式'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'PHOTOTYPE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'简历原文件名'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'RESUMEOLDNAME'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'简历新文件名'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'RESUMENEWNAME'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'简历格式'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'RESUMETYPE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'户籍所在地，编码（关联至TBCode_Area的CodeValue）'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'HuJiSuoZaiDi'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'户籍所在派出所'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'HUJIPAICHUSUO'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'工作时间'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'WORKDATE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'加入公司时间'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'JINRUDATE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'车牌号'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'CARNUMBER'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'QQ号'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'QQ'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'微信公众账号对应的OpenID'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'WEBCHATOPENID'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'创建时间'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'CREATEDATE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'创建者'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'CREATEUSER'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'修改时间'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'UPDATEDATE'</span></span><br><span class="line"><span class="keyword">GO</span></span><br><span class="line">EXEC sys.sp_addextendedproperty @<span class="keyword">name</span>=N<span class="string">'MS_Description'</span>, @<span class="keyword">value</span>=N<span class="string">'修改者'</span> , @level0type=N<span class="string">'SCHEMA'</span>,@level0name=N<span class="string">'dbo'</span>, @level1type=N<span class="string">'TABLE'</span>,@level1name=N<span class="string">'SYS_USERINFO'</span>, @level2type=N<span class="string">'COLUMN'</span>,@level2name=N<span class="string">'UPDATEUSER'</span></span><br><span class="line"><span class="keyword">GO</span></span><br></pre></td></tr></table></figure>
<p>当执行完脚本无误后，我们要根据现有的数据库更新EF实体模型。具体操作是在edmx空白区域右键→从数据库更新模型→选择所有表后点击完成</p>

                <!-- <hr> -->
                

                <ul class="pager">
                    
                    <li class="previous">
                        <a href="/2017/02/17/mvc-lesson5/" data-toggle="tooltip" data-placement="top"
                           title="Asp.net MVC系列教程5——登录功能, Spring, log4net">&larr; Previous Post</a>
                    </li>
                    
                    
                    <li class="next">
                        <a href="/2017/02/19/mvc-lesson7/" data-toggle="tooltip" data-placement="top"
                           title="Asp.net MVC系列教程7——创建与登录用户相关的接口和实现类">Next Post &rarr;</a>
                    </li>
                    
                </ul>

                <!-- social-share start -->
                <div class="social-share" style="padding-top:20px;text-align:center;"></div>
                <!--  css & js -->
                <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/social-share.js/1.0.16/css/share.min.css
                ">
                <script src="https://cdnjs.cloudflare.com/ajax/libs/social-share.js/1.0.16/js/social-share.min.js"></script>
                <!-- social-share end -->


                

                
                <!-- disqus 评论框 start -->
                <div class="comment">
                    <div id="disqus_thread" class="disqus-thread"></div>
                </div>
                <!-- disqus 评论框 end -->
                

            </div>

            <div class="hidden-xs col-sm-3 toc-col">
                <div class="toc-wrap">
                    <ol class="toc"><li class="toc-item toc-level-1"><a class="toc-link" href="#简述"><span class="toc-text">简述</span></a></li><li class="toc-item toc-level-1"><a class="toc-link" href="#索引"><span class="toc-text">索引</span></a></li><li class="toc-item toc-level-1"><a class="toc-link" href="#项目开始"><span class="toc-text">项目开始</span></a><ol class="toc-child"><li class="toc-item toc-level-4"><a class="toc-link" href="#表名：SYS-CODE"><span class="toc-text">表名：SYS_CODE</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#表名：SYS-CODE-AREA"><span class="toc-text">表名：SYS_CODE_AREA</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#表名：SYS-DEPARTMENT"><span class="toc-text">表名：SYS_DEPARTMENT</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#表名：SYS-MODULE"><span class="toc-text">表名：SYS_MODULE</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#表名：SYS-PERMISSION"><span class="toc-text">表名：SYS_PERMISSION</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#表名：SYS-POST"><span class="toc-text">表名：SYS_POST</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#表名：SYS-POST-DEPARTMENT"><span class="toc-text">表名：SYS_POST_DEPARTMENT</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#表名：SYS-POST-USER"><span class="toc-text">表名：SYS_POST_USER</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#表名：SYS-ROLE"><span class="toc-text">表名：SYS_ROLE</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#表名：SYS-ROLE-PERMISSION"><span class="toc-text">表名：SYS_ROLE_PERMISSION</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#表名：SYS-SYSTEM"><span class="toc-text">表名：SYS_SYSTEM</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#表名：SYS-USER-DEPARTMENT"><span class="toc-text">表名：SYS_USER_DEPARTMENT</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#表名：SYS-USER-PERMISSION"><span class="toc-text">表名：SYS_USER_PERMISSION</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#表名：SYS-USER-ROLE"><span class="toc-text">表名：SYS_USER_ROLE</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#表名：SYS-USERINFO"><span class="toc-text">表名：SYS_USERINFO</span></a></li></ol></li></ol></li></ol></li></ol>
                </div>
            </div>
        </div>

        <div class="row">
            <!-- Sidebar Container -->

            <div class="
                col-lg-8 col-lg-offset-2
                col-md-10 col-md-offset-1
                sidebar-container">

                <!-- Featured Tags -->
                
                <section>
                    <!-- no hr -->
                    <h5 class="text-center">
                        <a href="/tags/">FEATURED TAGS</a>
                    </h5>
                    <div class="tags">
                        
                        <a class="tag" href="/tags/#sql"
                           title="sql">sql</a>
                        
                    </div>
                </section>
                

                <!-- Friends Blog -->
                
            </div>
        </div>

    </div>
</article>

<div id="music">
    <audio id="bell" src="/music/Faded.mp3" preload="auto" loop autoplay></audio>
</div>
<!-- <embed style="position:fixed;right:0;bottom:0;"; src="http://www.xiami.com/widget/274513503_1776204257/singlePlayer.swf" type="application/x-shockwave-flash" width="257" height="33" wmode="transparent"></embed> -->
<!-- <embed style="position:fixed;right:0;bottom:-44px;"; src="http://www.xiami.com/widget/274513503_1775988866,1774426379,1770760772,1772121439,3567313,_235_246_FF8719_494949/multiPlayer.swf" allowscriptaccess="always" quality="high" wmode="opaque" menu="false" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="235" height="246" title="Adobe Flash Player"> -->
<!-- music control -->
<script src="/js/music.js"></script>

<div class="gotoTop"></div>
<script src="/js/gotoTop.js"></script>



<!-- disqus 公共JS代码 start (一个网页只需插入一次) -->
<script type="text/javascript">
    /* * * CONFIGURATION VARIABLES * * */
    var disqus_shortname = "guanghuiwang";
    var disqus_identifier = "https://wghglory.github.io/2017/02/17/mvc-lesson6/";
    var disqus_url = "https://wghglory.github.io/2017/02/17/mvc-lesson6/";

    (function () {
        var dsq = document.createElement('script');
        dsq.type = 'text/javascript';
        dsq.async = true;
        dsq.src = '//' + disqus_shortname + '.disqus.com/embed.js';
        (document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(dsq);
    })();
</script>
<!-- disqus 公共JS代码 end -->



<!-- Footer -->
<!-- Footer -->
<footer>
    <div class="container">
        <div class="row">
            <div class="col-lg-8 col-lg-offset-2 col-md-10 col-md-offset-1 text-center">
                <br>
                <ul class="list-inline text-center">
                
                
                

                

                
                <li>
                    <a target="_blank" href="https://www.jianshu.com/u/85d2cacc9fcd">
                                <span class="fa-stack fa-lg">
                                    <i class="fa fa-circle fa-stack-2x"></i>
                                    <i class="fa fa-stack-1x fa-inverse">简</i>
                                </span>
                    </a>
                </li>
                

                
                    <li>
                        <a target="_blank" href="https://www.facebook.com/wghglory">
                            <span class="fa-stack fa-lg">
                                <i class="fa fa-circle fa-stack-2x"></i>
                                <i class="fa fa-facebook fa-stack-1x fa-inverse"></i>
                            </span>
                        </a>
                    </li>
                

                
                    <li>
                        <a target="_blank"  href="https://github.com/wghglory">
                            <span class="fa-stack fa-lg">
                                <i class="fa fa-circle fa-stack-2x"></i>
                                <i class="fa fa-github fa-stack-1x fa-inverse"></i>
                            </span>
                        </a>
                    </li>
                

                
                    <li>
                        <a target="_blank"  href="https://www.linkedin.com/in/guanghuiwang">
                            <span class="fa-stack fa-lg">
                                <i class="fa fa-circle fa-stack-2x"></i>
                                <i class="fa fa-linkedin fa-stack-1x fa-inverse"></i>
                            </span>
                        </a>
                    </li>
                

                </ul>
                <p class="copyright text-muted">
                    Copyright &copy; Guanghui 2017
                    <br>
                    <span id="busuanzi_container_site_pv" style="font-size: 12px;">PV: <span id="busuanzi_value_site_pv"></span> Times</span>
                    <br>
                    Modified theme based on <a href="https://haojen.github.io/">Haojen Ma</a>' Anisina
                </p>

            </div>
        </div>
    </div>
</footer>

<!-- jQuery -->
<script src="/js/jquery.min.js"></script>

<!-- Bootstrap Core JavaScript -->
<script src="/js/bootstrap.min.js"></script>

<!-- Custom Theme JavaScript -->
<script src="/js/blog.js"></script>

<!-- code block fold/unfold button and copy button -->
<script src="/js/codeBlockEnhance.js"></script>

<!-- async load function -->
<script>
    function async(u, c) {
      var d = document, t = 'script',
          o = d.createElement(t),
          s = d.getElementsByTagName(t)[0];
      o.src = u;
      if (c) { o.addEventListener('load', function (e) { c(null, e); }, false); }
      s.parentNode.insertBefore(o, s);
    }
</script>

<!-- jquery.tagcloud.js -->
<script>
    // only load tagcloud.js in tag.html
    if($('#tag_cloud').length !== 0){
        async("https://wghglory.github.io/js/jquery.tagcloud.js",function(){
            $.fn.tagcloud.defaults = {
                //size: {start: 1, end: 1, unit: 'em'},
                color: {start: '#bbbbee', end: '#0085a1'},
            };
            $('#tag_cloud a').tagcloud();
        })
    }
</script>

<!--fastClick.js -->
<script>
    async("//cdn.bootcss.com/fastclick/1.0.6/fastclick.min.js", function(){
        var $nav = document.querySelector("nav");
        if($nav) FastClick.attach($nav);
    })
</script>

<!-- Google Analytics -->


<script>
    // dynamic User by Hux
    var _gaId = 'UA-91771069-1';
    var _gaDomain = 'wghglory.github.io';
    // Originial
    (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
                (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
            m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
    })(window,document,'script','//www.google-analytics.com/analytics.js','ga');
    ga('create', _gaId, _gaDomain);
    ga('send', 'pageview');
</script>


<!-- Baidu Tongji -->


<!-- swiftype -->
<script type="text/javascript">
  // (function(w,d,t,u,n,s,e){w['SwiftypeObject']=n;w[n]=w[n]||function(){
  // (w[n].q=w[n].q||[]).push(arguments);};s=d.createElement(t);
  // e=d.getElementsByTagName(t)[0];s.async=1;s.src=u;e.parentNode.insertBefore(s,e);
  // })(window,document,'script','//s.swiftypecdn.com/install/v2/st.js','_st');
  //
  // _st('install','undefined','2.0.0');
</script>

<script async src="//dn-lbstatics.qbox.me/busuanzi/2.3/busuanzi.pure.mini.js"></script>

<!--wechat title img-->
<img class="wechat-title-img" src="/images/avatar.jpg">
</body>

</html>
